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
- :
- Question on SQL SERVER 2008 R2 SP2 Pre-Req Quiet Install
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
‎Apr 05, 2015
12:42 PM
Question on SQL SERVER 2008 R2 SP2 Pre-Req Quiet Install
Hi All,
After reading several blogs, MSDN articles, and posts here on the community forums, I am asking for help with doing a quiet install of Sql Server 2008 R2 (with SP2) as one of the pre-reqs of my application. Here is what I have done so far:
1. added the pre req to the install project, making sure that all of the necessary pre reqs for Sql Server 2008R2 are added.
2. set the pre req install order to make sure the necessary pre reqs for Sql Server are installed first.
3. opened up the Sql Server pre req in the editor to set the command parms.
Those parms are as follows: /QS /HIDECONSOLE="True" /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS /FEATURES=SQLENGINE /INSTANCENAME=MSSQLSERVER /SECURITYMODE=SQL /SAPWD="**********" /TCPENABLED= 1 /SQLAUTOSTART=1 /AGTSVCACCOUNT="NT AUTHORITY\Network Service"
****************Additional information**************************
Just to add to my original post, I have also tried the following parms for the silent install, but I am STILL getting the same result.
/QS /Action=Install /Hideconsole /IACCEPTSQLSERVERLICENSETERMS /SkipRules=RebootRequiredCheck /FEATURES=SQLENGINE /InstanceName=MSSQLSERVER /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /AGTSVCSTARTUPTYPE=Automatic /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /ASSYSADMINACCOUNTS="NT AUTHORITY\Network Service" /SQLSYSADMINACCOUNTS="Builtin\Administrators" /BROWSERSVCSTARTUPTYPE=Automatic /SECURITYMODE=SQL /SAPWD=********* /ADDCURRENTUSERASSQLADMIN=True /TCPENABLED=1
******************************************************************
Now, the pre req is recognized during the install and the Sql install is unpacked, but then the UI is displayed to the user. This is what I need to avoid!
So What exactly am I missing or doing wrong here? I appreciate any and all responses to this!
Thanks in advance,
Eric
After reading several blogs, MSDN articles, and posts here on the community forums, I am asking for help with doing a quiet install of Sql Server 2008 R2 (with SP2) as one of the pre-reqs of my application. Here is what I have done so far:
1. added the pre req to the install project, making sure that all of the necessary pre reqs for Sql Server 2008R2 are added.
2. set the pre req install order to make sure the necessary pre reqs for Sql Server are installed first.
3. opened up the Sql Server pre req in the editor to set the command parms.
Those parms are as follows: /QS /HIDECONSOLE="True" /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS /FEATURES=SQLENGINE /INSTANCENAME=MSSQLSERVER /SECURITYMODE=SQL /SAPWD="**********" /TCPENABLED= 1 /SQLAUTOSTART=1 /AGTSVCACCOUNT="NT AUTHORITY\Network Service"
****************Additional information**************************
Just to add to my original post, I have also tried the following parms for the silent install, but I am STILL getting the same result.
/QS /Action=Install /Hideconsole /IACCEPTSQLSERVERLICENSETERMS /SkipRules=RebootRequiredCheck /FEATURES=SQLENGINE /InstanceName=MSSQLSERVER /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /AGTSVCSTARTUPTYPE=Automatic /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /ASSYSADMINACCOUNTS="NT AUTHORITY\Network Service" /SQLSYSADMINACCOUNTS="Builtin\Administrators" /BROWSERSVCSTARTUPTYPE=Automatic /SECURITYMODE=SQL /SAPWD=********* /ADDCURRENTUSERASSQLADMIN=True /TCPENABLED=1
******************************************************************
Now, the pre req is recognized during the install and the Sql install is unpacked, but then the UI is displayed to the user. This is what I need to avoid!
So What exactly am I missing or doing wrong here? I appreciate any and all responses to this!
Thanks in advance,
Eric
(3) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Apr 06, 2015
03:33 PM
Try /Q instead of /QS
QUIET Setup will not display any user interface.
QUIETSIMPLE Setup will display progress only, without any user interaction.
QUIET Setup will not display any user interface.
QUIETSIMPLE Setup will display progress only, without any user interaction.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Apr 07, 2015
02:22 PM
I did just that and at first it still brought up the UI.
Then I realized that I was putting the arguments into the box marked for the quiet install only. Once I put the arguments into the top box for the launching of the exe file, this worked. Thank you for that part of the answer.
However, I have a second issue now and I may need to make this a separate question, but will appreciate any and all insight into this one.
The SQL install did install and I verified that I could connect as I wanted to, but my main install file that I have the Sql install as a pre-req shows the sql install as having failed when it actually didn't. Any ideas on how I overcome that one? (I'm still searching Bing and Google as well)
Thanks!!
Eric
Then I realized that I was putting the arguments into the box marked for the quiet install only. Once I put the arguments into the top box for the launching of the exe file, this worked. Thank you for that part of the answer.
However, I have a second issue now and I may need to make this a separate question, but will appreciate any and all insight into this one.
The SQL install did install and I verified that I could connect as I wanted to, but my main install file that I have the Sql install as a pre-req shows the sql install as having failed when it actually didn't. Any ideas on how I overcome that one? (I'm still searching Bing and Google as well)
Thanks!!
Eric
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Apr 07, 2015
08:07 PM
So thanks to this answer on one of the threads here on the community forum, along with the answer below, I was finally able to do everything I wanted to with my install.
Thanks for all the help!!
Eric
Thanks for all the help!!
Eric