This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- how to detect presence of sql server
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
May 23, 2008
02:56 AM
how to detect presence of sql server
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.
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.
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
May 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.
Note that MSSQL.n is an instance identifier, where n is the ordinal number of the component being installed.
Hope that helps.