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).
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.
