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
- :
- MSSQL Server 2008 R2 Express Service Pack 2
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 31, 2012
02:56 AM
MSSQL Server 2008 R2 Express Service Pack 2
I am installing a MSSQL instance during our setup through an Installscript MSI project.
The first release of MSSQL 2008 R2 and the following Service Pack 1 works perfectly. But now the latest release hangs always at the same step and never ends.
The parameter did not change and are all the same. I am installing the Express Edition without Tools in German. It is a strange behaviour because the same edition in English, just works and installs without an error or hanging.
You can take a look in a logfile at C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120830_150732\Detail_ComponentUpdate.txt:
Looks like that the MSSQL setup is waiting for the Windows service "Windows Installer", but its not responding. Only killing the process manually can continue the MSSQL setup.
So anybody got some experience on that? Or any other workarounds to solve the problem?
Restarting the service "Windows Installer" during the InstallShield-Setup is not possible, because the service is locked and can be only killed manually.
The first release of MSSQL 2008 R2 and the following Service Pack 1 works perfectly. But now the latest release hangs always at the same step and never ends.
The parameter did not change and are all the same. I am installing the Express Edition without Tools in German. It is a strange behaviour because the same edition in English, just works and installs without an error or hanging.
You can take a look in a logfile at C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120830_150732\Detail_ComponentUpdate.txt:
2012-08-30 15:08:09 Slp: Running Action: Install_WatsonX86_Cpu32_Action
2012-08-30 15:08:09 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-08-30 15:08:09 Slp: Sco: Attempting to open registry subkey
2012-08-30 15:08:09 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\VisualStudio\9.0
2012-08-30 15:08:09 Slp: Sco: Attempting to get registry value InstallDir
2012-08-30 15:08:09 Slp: Sco: Waiting for service 'msiserver' to accept the stop request.
2012-08-30 15:08:09 Slp: Sco: Returning service status Running
2012-08-30 15:08:14 Slp: Sco: Returning service status Running
Looks like that the MSSQL setup is waiting for the Windows service "Windows Installer", but its not responding. Only killing the process manually can continue the MSSQL setup.
So anybody got some experience on that? Or any other workarounds to solve the problem?
Restarting the service "Windows Installer" during the InstallShield-Setup is not possible, because the service is locked and can be only killed manually.
(4) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 17, 2012
08:38 AM
Did you check if there is a pending reboot? Maybe this causes this behavior.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Sep 17, 2012
08:54 AM
Is this perhaps the same issue as http://connect.microsoft.com/SQLServer/feedback/details/741476/sql-server-2012-express-setup-issue in that they (Microsoft) appear to have removed support for a sql server express installation from within a running windows installer.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Apr 23, 2013
08:51 AM
Hi all,
I'm experiencing exactly the same behaviour (using InstallShield 2012 Spring - Professional Ed.)
Has anyone found a solution to this issue? (seeing as Microsoft do not appear to want to fix it themselves) 😞
The only "workaround" I could find is to change the SQL Server 2008 R2 Express prereq from a Feature pre-req to an Install before pre-req
(which is awful and unacceptable for our setup project)
Many thanks 🙂
I'm experiencing exactly the same behaviour (using InstallShield 2012 Spring - Professional Ed.)
Has anyone found a solution to this issue? (seeing as Microsoft do not appear to want to fix it themselves) 😞
The only "workaround" I could find is to change the SQL Server 2008 R2 Express prereq from a Feature pre-req to an Install before pre-req
(which is awful and unacceptable for our setup project)
Many thanks 🙂
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Apr 23, 2013
08:56 AM
The MS attitude is "won't fix" so I would not expect the behavior to change in the future. I have been meaning to look into the SQL Server LocalDB alternative to see if that may work differently but have not had the time to do so. I am puzzled why MS prevents developers from distributing SQL Server with their software, but hey that's just me. :confused:
![](/skins/images/D60DF682EA37BF37032955CE10F3F0BB/responsive_peak/images/icon_anonymous_message.png)