Silent installation of SQL Server 2008 Express in InstallShield

How To Silently Installation SQL Server 2008 Express in InstallShield 2010:

In InstallShield Application:

1.Go to Installation Designer Tab->Application Data->Redistributable

2.Find the “Microsoft SQL Server 2008 Express SP1 (x86 & x64Wow)” from the list and Check it.

3.(If Needed) If you already have a SQL Server Setup file “SQLEXPR_x86_ENU.exe” and get the message: “Needs to be downloaded”,from installShield,copy your file to “C:\Program Files (x86)\InstallShield\2010\Objects\SQL2008ExpressSP1\”, and you may have to create the folder yourself(first).

SqlServer2008SilentInstall_InstallShield_1

4.Right Click on “Microsoft SQL Server 2008 Express SP1(X86 & X64Wow” and  then Click on Edit Prerequisite.

5.Go to “Application to Run” tab and copy the below command into “Specify command line for the application” text box :

/qs /INSTANCEID=”SQLEXPRESS” /ACTION=”Install” /FEATURES=SQLENGINE /INSTANCENAME=”SQLEXPRESS” /SQLSVCACCOUNT=”NT AUTHORITY\SYSTEM” /SQLSYSADMINACCOUNTS=”Builtin\Administrators” /ADDCURRENTUSERASSQLADMIN

SqlServer2008SilentInstall_InstallShield_2

6.(Optional) If your application can work with another version of SqlServer2008Express and you don’t want to install another instance on the destination computer you would:

6.1.Go to Conditions path and select the first item in row and click the “Modify” button.

6.2.Select the first option “A register key does or does not exist” and then copy the below text for register key name:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLEXPRESS\MSSQLServer\CurrentVersion

6.3.Now please select the “Default” mode and finally choose the “If the specified registry key DOES NOT EXIST” option.SqlServer2008SilentInstall_InstallShield_3

7.(Optional) If you want the installation to be continued even with any problem, go to “Behavior” tap and select the “Continue the Setup” option in the first combo box.

At the end,you should close the dialog and Click “Yes” to Save the changes.

July,2015