This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
peterbi
Level 7
‎Jul 10, 2009 05:22 PM

Registry to check SQL Server instances?

Hi,

I wonder if anybody can help me on what registry entry (ies) to use to check SQL Server instances installed on the system?


I want to cover MS SQL7/MSDE2000/SQL2005Expr./SQL2005/SQL2008, I hope I can do it on a simple registry checking function. Currently I am using the following registry:

HKLM\\SOFTWARE\\Microsoft\\Microsoft SQL Server with name "InstalledInstances"

It works with SQL2005Expr. and probably SQL2005 (maybe also SQL2008?), but not sure on SQL7 and MSDE.


Thanks,
Peter
Labels (1)
Labels
0 Kudos
(1) Reply
hidenori
Level 17
‎Jul 13, 2009 02:46 PM

I think that MSDE and SQL Server 7 use the registry key as well.
0 Kudos