Identying all installed SQL Server instances on a machine

I think I would use the SQL-DMO object to find SQL instances, then
filter that list to just the single computer you want to query. =20
Ref: http://www.sqlteam.com/item.asp?ItemID=3D5403
Good luck,
Tony Sebion
--Original Message--
From: Volcano [mailto:Volcano@.discussions.microsoft.com]=20
Posted At: Wednesday, August 03, 2005 11:55 AM
Posted To: programming
Conversation: Identying all installed SQL Server instances on a machine
Subject: Identying all installed SQL Server instances on a machine
Hi,
I want to programmatically identify all SQL Server (2000 or 2005)
instances installed on a machine with Windows 2000 or 2003. One way is
to browse through the Windows registry and look for specific keys such
as HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server. But the
registry is organized differently for SQL 2005 than SQL 2000 and maybe
it will change again for the next SQL version. And things get messy when
both SQL 2000 & SQL
2005 instances co-exist on the same host. So is there an API I can use
to find the instances and not rely on Windows registry?
Thanks in advances for any pointers.
- VolcanoTony & ML:
Thanks a lot for the pointer.
- V
"Tony Sebion" <tony@.sebion.com> wrote in message
news:VlIkTDFmFHA.7716@.taurus.ad.nosellout.net...
I think I would use the SQL-DMO object to find SQL instances, then
filter that list to just the single computer you want to query.
Ref: http://www.sqlteam.com/item.asp?ItemID=5403
Good luck,
Tony Sebion
--Original Message--
From: Volcano [mailto:Volcano@.discussions.microsoft.com]
Posted At: Wednesday, August 03, 2005 11:55 AM
Posted To: programming
Conversation: Identying all installed SQL Server instances on a machine
Subject: Identying all installed SQL Server instances on a machine
Hi,
I want to programmatically identify all SQL Server (2000 or 2005)
instances installed on a machine with Windows 2000 or 2003. One way is
to browse through the Windows registry and look for specific keys such
as HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server. But the
registry is organized differently for SQL 2005 than SQL 2000 and maybe
it will change again for the next SQL version. And things get messy when
both SQL 2000 & SQL
2005 instances co-exist on the same host. So is there an API I can use
to find the instances and not rely on Windows registry?
Thanks in advance for any pointers.
- Volcano