Installing SQL Express 2014 with a custom action

[hkjang]

I've been installing SQL Express 2008 SP2 with my InstallShield setup (Basic MSI) using a custom action.
It's not pre-requisite or feature-based requisite. I have a dialog asking user if they want to install SQL Express.
Now comes the time to update SQL Express to 2014 version.
But, I found out yesterday that Microsoft has changed how SQL Express installs from 2008 R2 and up to restart Windows Installer service in the middle of the installation, so it can't be spawned from InstallShield setup.
They even say it here: http://support.microsoft.com/kb/2820068/en-us
I saw someone's posting saying to make it pre-requisite, but I'd like to give users a choice whether they want to install it or not.
Since it's been a while since Microsoft released SQL Express R2, I'd like to believe that someone must have had a workaround for this.
Could you please share how you got around this issue?
Thanks.

[javerson]

were you able to install sql express 2014 via installshield ?

Thank you

[hkjang]

Yes, I was.
The key was to add "/SKIPINSTALLERRUNCHECK" in the command line.
Hope this helps!

[gsadu_markemim]

Hi,

can you please explain me how you have use the custom action to install sql express silently.

Thanks & Regards

bhaskar

[Varaprasad]

Microsoft claims that this issue is fixed as part of Cumulative update 2 for SQL Server 2014 SP1, but not sure about SQL Express edition. Did you try with SQL Server 2014 (SP3) Express?

https://www.microsoft.com/en-us/download/details.aspx?id=57473

On the other end, there is a way you can give users a choice whether to install a prerequisite or not. Please refer below link:

https://helpnet.flexerasoftware.com/installshield23helplib/helplibrary/SetupPrereqEditorSkipInstall.htm#definingprerequisites_1345817975_1029192