Named vs Default
-
This might sound simple, but how do you determine if an existing Instance of SQL Server 2000 is a named instance or a default instance? I have one Virtual Instance already in a Clustered Environment. I need to add a second and I don't know how to tell if that first one is default or named?? I believe I read that you can only have one 'default' instance per ...
Thank you in advance.
-
The first installation of SQL Server 2000 on a server that does not have any version of SQL Server already installed on it will typically be the default installation. Their is a screen with about default and named instances. The Default Instance checkbox is marked by default. All future installations of SQL Server 2000 on that same server will be named instances. In your case, your first installation should be default installation.
The easiest way to check is to connect to the server using query analyzer or enterprise manager. In the case of a default instance, you would just use the server's name to connect to it. In the case of a named instance, you must use the server name along with the instance name in the following configuration SERVERNAME\INSTANCENAME to connect to that instance.
Check this link to MSDN to get more information on clustering and named instances. The info is at the bottom of the page.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_7t9v.asp
Hope this helps.
-
The following query returns NULL if you are connected to a default instance; otherwise, it returns the instance name:
SELECT ServerProperty('InstanceName')
Easy, huh?
Cheers,
Chris
-
Thank you!!!!!!!!!
-
You're welcome!!!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply