1) Open Installation Wizard
2) Select Feature You want to install
3) Provide installation configuration
4) Now that you have the configuration file, copy it to your own folder or network share where you want to start the unattended installation.
5) Cancel setup as we are interested in the unattended silent mode of installation; not the UI one.
6) Edit the configuration file as follows:
- Set QUIET to “True”. This specifies that Setup will run in a quiet mode without any user interface
i. QUIET="True"
- Set SQLSYSADMINACCOUNTS to “BUILTINADMINISTRATORS”. This will ensure that administrators on the machine are added as members of the sysadmin role. You can set its value based on your needs (Ex: SQLSYSADMINACCOUNTS=”domainYourUser”), but this is the more generic approach. I have added My user instead of
BUILTINADMINISTRATORS, to secure SQL server from unwanted logins.
i. SQLSYSADMINACCOUNTS="BUILTINADMINISTRATORS"
- Add PID and set its value to your product license key. If your setup.exe already comes preloaded with the key, there is no need to add this option to the configuration file.
- Add IACCEPTSQLSERVERLICENSETERMS and set its value to “True”. This is to require to acknowledge acceptance of the license terms at time of unattended installations.
i. IACCEPTSQLSERVERLICENSETERMS="True
- Remove the ADDCURRENTUSERASSQLADMIN parameter. The reason is that this parameter can’t be used when SQLSYSADMINACCOUNTS is specified, and it only applies to Express installations.
- Remove the UIMODE parameter as it can’t be used with the QUITE parameter.
- Remove INSTALLSHAREDDIR, INSTALLSHAREDWOWDIR, INSTANCEDIR parameters if you want to install on the default installation directories or mention appropriate directories for installation.
- You can add or remove the feature you want to install, Select FEATURES=SQLENGINE,SSMS,ADV_SSMS in the configuration file. You can change that based on your needs.
- The full list of available feature parameters and their descriptions : http://msdn.microsoft.com/en-us/library/ms144259.aspx#Feature
- Now, Your configuration file is ready, you need to create a batch file that will run the silent unattended setup. Create a new file ”SQLServer2012_SilentInstall” with extension = “.bat”.
We have added, Date time to get the time taken by complete installation. Edit below script with your setup & configuration file location.
@ECHO offecho Installing SQL Server 2008 R2date/ttime /t
“D:SQLFULL_x86_ENUsetup.exe” /ConfigurationFile=”D:ConfigurationFile.ini” date/t time /t |
7) My SQL Server got installed
8) Let’s Verify
If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun
Reference : Rohit Garg (http://mssqlfun.com/)
great it’s a cool stuff
[…] http://mssqlfun.com/2013/01/29/sql-server-silent-unattended-installation-using-configuration-file/ […]
I think it missing one thing. It is the SAPWD setting that it must be specified in MIXED Authentication mode no ?
Thanks for Add in !
I think it misses one setting in your article which is conditional but important. When you choose to use MIXED AUTHENTICATION MODE you need to specified the SAPWD value in the file which is not default present. Just a complement to your marvelous job on this subject :-D. Thanks for all.
Thanks for Add in !
I comment when I especially enjoy a post on a website or if I have
something to add to the discussion. It’s caused by the passion displayed in the article
I looked at. And on this post SQL Server Silent unattended installation using configuration file « MSSQLFUN.
I was moved enough to drop a commenta response 😉 I do have 2 questions for you if it’s allright.
Is it just me or do a few of these comments appear like left
by brain dead people? 😛 And, if you are writing at other places, I’d like to follow everything fresh you have to post.
Could you list the complete urls of your communal sites
like your Facebook page, twitter feed, or linkedin profile?
Thanks for the interest !
http://www.mssqlfun.com
https://www.facebook.com/Mssqlfun
http://in.linkedin.com/in/rohitgarg1986
https://twitter.com/Rgarg86
If I wanted to automate my sql instance installs, can I run the script multiple times against the same server, just changing the instance name?
If the answer is yes, when a second install is running, will the first instance installed become unavailable until the second install is complete?
useful information
Thank you for the assistance, with some trouble shooting, this guide was successful with sql server 2014 in Hyper-V Server 2012 r2 core
THANKS! The ones that needed to be removed was super helpful
[…] SQL Server Silent unattended installation using … – 5) Cancel setup as we are interested in the unattended silent mode of installation; not the UI one. 6) Edit the configuration file as follows: Set QUIET to “True”. […]
can we do it on multiple machines at the same time?
NO REMOTE installation supported. You can create one config file and it on multiple machine but cannot execute it remotely on multiple machines.