PDA

View Full Version : how to detect presence of sql server



rajesh@excelenc
05-23-2008, 02:56 AM
Hi,

Before I start the installation, I need to detect if either MS SQL Server Express or any flavor of sql server (Standard, Developer, Enterprise) is installed on the target machine or not.

I am using Installshield Express 2008, what would be the best way to detect the above condition. If I have to make use of registry key settings what would be the key/value which I need to look for.

Pls note I need to detect any flavor of sql server (express or the Standard, Developer, Enterprise ones).

Looking forward for any kind of help on this.

hidenori
05-27-2008, 02:05 PM
The installed instance names and identifiers are listed under the HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL key. To determine an edition, you can look up the Edition value name under the HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSSQL.n\Setup key.

Note that MSSQL.n is an instance identifier, where n is the ordinal number of the component being installed.

Hope that helps.