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
- :
- Determine if the SQL Server 2008 R2 Express SP2 prerequisite completed successfully
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
‎Oct 21, 2013
12:31 PM
Determine if the SQL Server 2008 R2 Express SP2 prerequisite completed successfully
Hi,
I'm trying to use the SQL Server 2008 R2 Express SP2 (x86) prerequisite and it appears to install successfully but after the prerequisite setup completes I get a message that says:
"The installation of the Microsoft SQL Server 2008 R2 Express SP2 (x86) appears to have failed. Do you want to continue the installation?"
I've used some other prerequisites before and I don't get this message. I've reviewed the SQL Server setup logs on the machine and I can't find any errors logged by the setup.
How does IS determine if the prerequisite has completed successfully?
The command line in the SQL Server 2008 R2 Express SP2 (x86) prerequisite is:
/QS /Action=Install /IAcceptSQLServerLicenseTerms /INSTANCENAME=TESTINST /FEATURES=SQL,AS,Tools /ROLE=AllFeatures_WithDefaults /SQLSYSADMINACCOUNTS="BUILTIN\Administrators" /ADDCURRENTUSERASSQLADMIN=TRUE /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /SECURITYMODE=SQL
Is there something I'm missing?
Thanks,
Nick
I'm trying to use the SQL Server 2008 R2 Express SP2 (x86) prerequisite and it appears to install successfully but after the prerequisite setup completes I get a message that says:
"The installation of the Microsoft SQL Server 2008 R2 Express SP2 (x86) appears to have failed. Do you want to continue the installation?"
I've used some other prerequisites before and I don't get this message. I've reviewed the SQL Server setup logs on the machine and I can't find any errors logged by the setup.
How does IS determine if the prerequisite has completed successfully?
The command line in the SQL Server 2008 R2 Express SP2 (x86) prerequisite is:
/QS /Action=Install /IAcceptSQLServerLicenseTerms /INSTANCENAME=TESTINST /FEATURES=SQL,AS,Tools /ROLE=AllFeatures_WithDefaults /SQLSYSADMINACCOUNTS="BUILTIN\Administrators" /ADDCURRENTUSERASSQLADMIN=TRUE /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /SECURITYMODE=SQL
Is there something I'm missing?
Thanks,
Nick
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 21, 2013
01:28 PM
Make sure that you have updated the registry condition of the prerequisite to test the TESTINST instance installed successfully. The original condition is designed to test the default named instance called SQLEXPRESS.
Original:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLEXPRESS\MSSQLServer\CurrentVersion
Change to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\TESTINST\MSSQLServer\CurrentVersion
Hope that helps.
Original:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLEXPRESS\MSSQLServer\CurrentVersion
Change to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\TESTINST\MSSQLServer\CurrentVersion
Hope that helps.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 21, 2013
03:39 PM
Hi Hidenori,
You are a genius! That did it. My SQL Server Express installed and then my setup started just like I want. 🙂
On a somewhat related topic, do you know if it's possible to control the inclusion of the SQL Server 2008 R2 Express SP2 (x86) prerequisite programatically? I have a program that uses the IS COM interface to programatically turn on and off different features in the application before I actually do a build and I'd like to have the same control over the SQL Server 2008 R2 Express SP2 (x86) prerequisite. I haven't been able to find anything in the documentation about this. Is that even supported? Oh and my IS project is an IS InstallScript project type.
Thanks
Nick
You are a genius! That did it. My SQL Server Express installed and then my setup started just like I want. 🙂
On a somewhat related topic, do you know if it's possible to control the inclusion of the SQL Server 2008 R2 Express SP2 (x86) prerequisite programatically? I have a program that uses the IS COM interface to programatically turn on and off different features in the application before I actually do a build and I'd like to have the same control over the SQL Server 2008 R2 Express SP2 (x86) prerequisite. I haven't been able to find anything in the documentation about this. Is that even supported? Oh and my IS project is an IS InstallScript project type.
Thanks
Nick
![](/skins/images/CC38E504FC9E1309DC48ACFEB4925670/responsive_peak/images/icon_anonymous_message.png)