SQL Server 2012 prerequisite fix

[DLee65]

Hey there fellow installers, for a few years we have been plagued with a problem using SQL Server 2008 R2 and SQL Server 2012 where if we included it as a prerequisite in a MSI project, that the SQL Server package will hang.

I was just reviewing the changes for SQL Server 2012 SP2 and there is cause for much rejoicing!
http://support.microsoft.com/kb/2820068

This ONLY works for SQL Server 2012 SP2 and SQL Server 2014.
On your command line for these packages, add the following parameter: "/SkipInstallerRunCheck"

I have not tested this but it was this issue that caused me to move to using the Suite Package for deploying all of our prerequisites. However, with this fixed, all of the work should be able to be done using the basic MSI again, just as we all did using SQL Server 2005.

[DandamanAUS]

Have you tried this and confirmed it?

Because we used to deploy 2008 Express and with our new version 2012 could be deployed dur to that error.

But if the new version does work I can once again create a full installation with SQL Express I will spend the time to do it if you can confirm it actually does work.

[DLee65]

I have not tried it but the new property is documented. We currently distribute SQL Server 2012 SP1. Also I doubt we are going to change our current Suite / Advanced UI setup any time soon.

I think I will download it today and give it a shot to see what happens. Hopefully they have a redistributable ready.

[DLee65]

Here is the documentation. However, I have not found a downloadable redistributable for SQL Server 2012 SP2. If you find one perhaps you can post the link here. I will continue to search for one as well.

https://support.microsoft.com/en-us/kb/2958429/
1190211 Installation of SQL Server by using InstallShield ends up in a hang state. For more information, go to this Knowledge Base article.

https://support.microsoft.com/en-us/kb/2820068/
From the Linked Site
Can't install SQL Server by using InstallShield or bootstrapping application

Symptoms
When you try to install Microsoft SQL Server by using InstallShield or a bootstrapping application, the installation process freezes.

Note This issue also occurs on Microsoft SQL Server 2012 Service Pack 2 (SP2).
Cause
This occurs because InstallShield or the bootstrapping application keeps open some Windows Installer handlers when you run the SQL Server setup. Therefore, the installation process freezes.
Workaround
To work around this issue, run the SQL Server setup program directly from the SQL Server installation media without wrapping the Setup program inside InstallShiled or a bootstrapping application.

For SQL Server 2014 and SQL Server 2012 SP2 and later versions, run the SQL Sever setup program together with SkipInstallerRunCheck command line parameter to skip Windows Installer handle check:
Setup.exe /SkipInstallerRunCheck

Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

[DLee65]

I just found the link to SQL Server(r) 2012 Service Pack 2 (SP2) Express.
https://www.microsoft.com/en-us/download/details.aspx?id=43351
The download link for the x86 version is: http://download.microsoft.com/download/0/1/E/01E0D693-2B4F-4442-9713-27A796B327BD/SQLEXPR_x86_ENU.exe. You can place this in your web download link.

The following has command line information but it does not include the new /SkipInstallerRunCheck
https://technet.microsoft.com/en-us/library/ms144259(v=sql.110).aspx#Install

[DLee65]

I can CONFIRM that SQL Server 2012 SP2 works as a feature prerequisite for a basic MSI package.