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
- :
- Install SQL Server 2008 Express Silently With My Application Setup
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
Dec 12, 2010
12:01 AM
Install SQL Server 2008 Express Silently With My Application Setup
Dear Experts
I want to install microsoft sql server 2008 express edition silently with my setup. As I dont want my customers to download and install the sql server manually. So I am looking to embed the sql server express 2008 within my setup using install shield 2010 preminum edition.
To do so I did the following steps in installshield 2010 premium edition
Edited PRQ file using Prerequisite Editor with below information
Added
SQLEXPRWT_x86_ENU.exe to the "Files To Include" tab.
Also added
SQLEXPRWT_x86_ENU.exe to the "Application to Run" tab in the "Specify the application you wish to launch:" text box.
Added
/q /INSTANCENAME="SQLEXPRESS2" /ACTION="Install" /FEATURES=SQLENGINE,SSMS /HELP="False" /INDICATEPROGRESS="False" /QUIETSIMPLE="True" /X86="True" /ERRORREPORTING="False" /SQMREPORTING="False" /SQLSVCSTARTUPTYPE="Automatic" /FILESTREAMLEVEL="0" /ENABLERANU="True" /SQLCOLLATION="Latin1_General_CI_AS" /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS="BUILTIN\Administrators" /SECURITYMODE="SQL" /ADDCURRENTUSERASSQLADMIN="True" /TCPENABLED="1" /NPENABLED="0" /SAPWD="qwerty123"
To the "Specify the command line for the application:" text box
Added
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100
to the "Conditions" tab and set it to
install if "Registry Key Does NOT exist"
Then saved it and reference it in your "Redistributables View"
As far as other prerequisities are concerned they are already installed on the machine.
When I run my custom setup on the client machine sql server 2008 express crashed in between with an error message as
"Specifying more than one quite mode setting is not supported. specifying either /q or /qs".
I tried by changing the parameter from /q to /qs the embeded sql setup works fine, but I dont need to run the sql setup like this as in this case the gui screen of the sql are visible and ask for some user intervention.
Please let me know what is wrong in the PRQ setting so that I will be in a position to run the SQL server silently with my setup.
With Regards
Hussain
I want to install microsoft sql server 2008 express edition silently with my setup. As I dont want my customers to download and install the sql server manually. So I am looking to embed the sql server express 2008 within my setup using install shield 2010 preminum edition.
To do so I did the following steps in installshield 2010 premium edition
Edited PRQ file using Prerequisite Editor with below information
Added
SQLEXPRWT_x86_ENU.exe to the "Files To Include" tab.
Also added
SQLEXPRWT_x86_ENU.exe to the "Application to Run" tab in the "Specify the application you wish to launch:" text box.
Added
/q /INSTANCENAME="SQLEXPRESS2" /ACTION="Install" /FEATURES=SQLENGINE,SSMS /HELP="False" /INDICATEPROGRESS="False" /QUIETSIMPLE="True" /X86="True" /ERRORREPORTING="False" /SQMREPORTING="False" /SQLSVCSTARTUPTYPE="Automatic" /FILESTREAMLEVEL="0" /ENABLERANU="True" /SQLCOLLATION="Latin1_General_CI_AS" /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS="BUILTIN\Administrators" /SECURITYMODE="SQL" /ADDCURRENTUSERASSQLADMIN="True" /TCPENABLED="1" /NPENABLED="0" /SAPWD="qwerty123"
To the "Specify the command line for the application:" text box
Added
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100
to the "Conditions" tab and set it to
install if "Registry Key Does NOT exist"
Then saved it and reference it in your "Redistributables View"
As far as other prerequisities are concerned they are already installed on the machine.
When I run my custom setup on the client machine sql server 2008 express crashed in between with an error message as
"Specifying more than one quite mode setting is not supported. specifying either /q or /qs".
I tried by changing the parameter from /q to /qs the embeded sql setup works fine, but I dont need to run the sql setup like this as in this case the gui screen of the sql are visible and ask for some user intervention.
Please let me know what is wrong in the PRQ setting so that I will be in a position to run the SQL server silently with my setup.
With Regards
Hussain
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Dec 13, 2010
09:11 AM
extract the .msi; make a transform for your specific application; call a reinstall of SQL Server with your transform.