Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
MS SQL Server instance name
0 views
Skip to first unread message
Dhiren
Dec 26, 2001, 3:15:24 PM12/26/01
to
Hello there,
How can I get list instance names of installed MS SQL Server on a local
machine ?
Two SQL Server can be installed on one machine with different instance name.
How can I get name of them ?
Regards
Dhiren
Michael Pham
Jan 2, 2002, 3:12:05 PM1/2/02
to
There's two ways that I know of off-hand. The first is a registry key. Check
HKLM\Software\Microsoft\Microsoft SQL Server. There's a key there named
InstalledInstances that will represent all the instances on that server.
HKLM\Software\Microsoft\Microsoft SQL Server. There's a key there named
InstalledInstances that will represent all the instances on that server.
The second way is using SQL-DMO and have it list all the servers on the
local machine (really, it just iterates through the registry anyway, among
other things). Different SQL Servers will show up with the
SERVERNAME\INSTANCE, like SERVER1\MSSQLSERVER (default instance) or
SERVER1\MYINSTANCE (named instance).
Hope this helps!
"Dhiren" <Dhi...@Icode.com> wrote in message news:3c2a2ce6$1_2@dnews...
0 new messages