InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
If You Are Given Access To A Sql Server, How Do You Find If The Sql Instance Is A Named Instance Or A Default Instance? |
|
Answer» I would go to the SQL Server CONFIGURATION Manager.In the left pane of the tool, I would select SQL Server Services, the right side pane displays all of the SQL Server Services / components that are installed on that MACHINE. If the SERVICE is DISPLAYED as (MSSQLSERVER), then it INDICATES it is a default instance, else there will be the Instance name displayed. I would go to the SQL Server Configuration Manager.In the left pane of the tool, I would select SQL Server Services, the right side pane displays all of the SQL Server Services / components that are installed on that machine. If the Service is displayed as (MSSQLSERVER), then it indicates it is a default instance, else there will be the Instance name displayed. |
|