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
- :
- Error installing SQL Server 2005 prerequisite
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
‎Aug 28, 2007
01:21 PM
Error installing SQL Server 2005 prerequisite
We use Installshield's Microsoft SQL Server 2005 Express SP1 setup prerequisite (installed locally) in our basic MSI installation when we install our app. But at the end of the SQL Server install, before the launch of our MSI, we get the following error, with no further info:
The installation of Microsoft SQL Server 2005 Express SP1 appears to have failed. Do you want to continue the installation?
If we click continue, our MSI launches and all our SQL connections and scripts run just fine, and we get no further errors. And our app runs just fine and SQL Server 2005 appears to be running without problems.
However, on subsequent reinstalls or updates, the SQL prerequisite doesn't see that SQL is already installed and goes through the same process again.
Any ideas? TIA
-Pat
The installation of Microsoft SQL Server 2005 Express SP1 appears to have failed. Do you want to continue the installation?
If we click continue, our MSI launches and all our SQL connections and scripts run just fine, and we get no further errors. And our app runs just fine and SQL Server 2005 appears to be running without problems.
However, on subsequent reinstalls or updates, the SQL prerequisite doesn't see that SQL is already installed and goes through the same process again.
Any ideas? TIA
-Pat
(4) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Aug 28, 2007
06:02 PM
I'm having this same issue all of a sudden and would be very curious as to why.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Aug 29, 2007
11:41 AM
Upon further investigation, I'm seeing that on subsequent installs, ALL of SQL Express is not installing, just "Setup Support Files", and then the error. So it seems that just just that 1 component of the prerequisite isn't installing correctly.
I'm thinking that I've got a corrupt prerequisite file. Can I remove it and then re-download the Installshield prerequisite?
-Pat
I'm thinking that I've got a corrupt prerequisite file. Can I remove it and then re-download the Installshield prerequisite?
-Pat
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Aug 29, 2007
01:13 PM
My issue is a little different as the actual installation of SQL Server is successful.. yet IS still thinks it is failing, which then throws that errror message. What could be triggering this response?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 26, 2007
02:03 PM
My SQL 2005 Express SP2 prerequisite that I created by hand reported a false negative as you have. Solved it by adding an additional condition to the prerequisite:
I used < because I'm checking to upgrade anything less than SP2, but the same or similar might work for you too.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\INSTANCENAME\MSSQLServer\CurrentVersion
CurrentVersion < 9.00.3042.00
I used < because I'm checking to upgrade anything less than SP2, but the same or similar might work for you too.
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)