Detecting if SQL Server 2008 is installed

Question

I am using dotNetInstaller as a bootstrapper and I need to detect if SQL Server 2008 or above is installed as a prerequisite.

Currently I am using this registry to detect the installation: HKLM\SOFTWARE\Microsoft\Microsoft SQL Server 2008 Redist\SharedManagementObjects\1033\CurrentVersion\Version

If the value of Version is 10.0.0 or higher it detects it as installed. We tried the installation package on 10 machines here (Windows XP SP3 & Windows 7) and the prerequisite worked fine. We are getting reports from a lot of people that although they have SQL 2008 installed it does not detect the install.

From the log:

2010-07-13 09:33:49 Checking whether registry value 'SOFTWARE\Microsoft\Microsoft SQL Server 2008 Redist\SharedManagementObjects\1033\CurrentVersion\Version' exists
2010-07-13 09:33:49 Opening 64-bit registry view (KEY_WOW64_64KEY)
2010-07-13 09:33:49 *** No registry key found: SOFTWARE\Microsoft\Microsoft SQL Server 2008 Redist\SharedManagementObjects\1033\CurrentVersion\Version, default value: false
2010-07-13 09:33:49 -- Microsoft SQL Server 2008 R2 x86 (Microsoft SQL Server 2008 R2 x86 Express): NOT INSTALLED

dotNetInstaller Check:

<installedcheck type="check_registry_value"
                                            rootkey="HKEY_LOCAL_MACHINE"
                                            path="SOFTWARE\Microsoft\Microsoft SQL Server 2008 Redist\SharedManagementObjects\1033\CurrentVersion"
                                            fieldname="Version"
                                            fieldtype="REG_SZ"
                                            fieldvalue="10.0.0"
                                            comparison="version_ge"
                                            wowoption="WOW64_64"
                                            defaultvalue="False"
                                            description="Installed Check" />

Does anyone know the definitive key to check?

Nate Zaugg · Accepted Answer · 2010-07-20 20:26:37Z

2

I believe the key I was using only detects if the tools are installed. I'm going to use this key: SOFTWARE\Microsoft\Microsoft SQL Server\100\Bootstrap Release\1033\CurrentVersion\Version

answered Jul 20, 2010 at 20:26

Nate Zaugg

4,2382 gold badges40 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Michael Phillips · Accepted Answer · 2011-11-30 11:08:56Z

2

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Bootstrap\Setup

PatchLevel

Appears to be a more likely candidate as it's updated by both the R2 and R2 SP1 installations.

answered Nov 30, 2011 at 11:08

Michael Phillips

8622 gold badges7 silver badges20 bronze badges

Comments

Colin Pickard · Accepted Answer · 2010-07-15 16:34:48Z

1

They're not using SQL Server 2008 Developer Edition are they? I think the key might be different at the "Microsoft SQL Server 2008 Redist" level, but I don't have it here to check.

answered Jul 15, 2010 at 16:34

Colin Pickard

46.8k13 gold badges105 silver badges152 bronze badges

1 Comment

Nate Zaugg Over a year ago

SQL Server 2008 Express for all

Collectives™ on Stack Overflow

Detecting if SQL Server 2008 is installed

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related