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 SQL Express during installation process?
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
‎Jun 26, 2007
10:57 AM
How to detect SQL Express during installation process?
I want to install SQL Express after user select certain options from the GUI. Once its determine (based on user inputs) that SQL express is required, I want to detect if its installed. If not then it will proceed with SQL Express installation.
What is the best way to detect SQL Express.
Note: I am using InstallshieldMSI project. Installing SQL Express as prerequisite is not an option for us.
Thanks is advance
What is the best way to detect SQL Express.
Note: I am using InstallshieldMSI project. Installing SQL Express as prerequisite is not an option for us.
Thanks is advance
(3) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 26, 2007
02:12 PM
My first reaction is to use LaunchAppAndWait to execute the redistributable. You can package the redistributable in with your support files or leave it uncompressed on the Disk1 folder.
To determine if it is installed I would just look for the registry entry for it.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90
To determine if it is installed I would just look for the registry entry for it.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 26, 2007
02:25 PM
Thanks for your answer. With LaunchAppandWait, SQLExpress installs with no problem. Thanks
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 21, 2010
04:59 PM
Actually, I've found that registry key to be unreliable for detecting SQL Server.
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90"
That key is shared by SQL Server Native Client and other SQL components. The user could have one of the components installed and not the full SQL database, causing your setup to report falsely.
Can anyone recommend a more reliable key in the registry?
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90"
That key is shared by SQL Server Native Client and other SQL components. The user could have one of the components installed and not the full SQL database, causing your setup to report falsely.
Can anyone recommend a more reliable key in the registry?