All versions of SQL Server Registry Key

Question

Is there a registry value that I can check to check if any version of SQL Server is installed? I want to check one value ... not a value for 2005, another for 2008, etc.

Answer 1

I had the same problem. I do not think there is room for one stop for this.

What really complicates this is the concept of named instances - where you can have multiple versions of sql installed on the same computer.

For instance:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Inst1\MSSQLServer\CurrentVersion
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Inst2\MSSQLServer\CurrentVersion

For SQL 2008, at least you can list the list of instances on
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL

Answer 2

What about

HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion

Answer 3

, ( ) SQL Server 2008 SQL Server 2008 R2