asked
Unattened Installation of Sql Server Using Config File
I am Trying to do a Unattended installation of Sql Server And I am getting some Errors like [alt text][1] But i am getting same GUI style of installation ,And my Config is of like this **[Options] \ACTION="INSTALL" \INSTANCENAME="MSSQLSERVER1007 \INSTANCEID="MSSQLSERVER1007" \AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" \AGTSVCSTARTUPTYPE="Automatic"ASSVCSTARTUPTYPE="Automatic" \ASCOLLATION="Latin1_General_CI_AS" \SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" \SQLSYSADMINACCOUNTS="GLOBALRCP\UnishB" \ SAPWD="grcp@123" \SECURITYMODE="SQL" \ADDCURRENTUSERASSQLADMIN="True"** Plzz suggest me suggestion that i can do a complete installation using unattended way [link text][2]-capture3.png [1]: /storage/temp/1723 [2]: /storage/temp/1724-configee.txt
From what I can see it appears you have the SAPWD in the config file. The password can not be stored in the config ini file security reasons, you must pass it to the config file. I have a blog post showing how to do this.
http://sqlaj.wordpress.com/2012/03/09/installing-sql-server-from-a-configuration-file/ Hope this helps.
Follow the below; 1.Create windows scheduler job or use any 3rd party tools. 2.Run below command or create btach file. start /wait C:\software\setup.exe /configurationfile=C:\software\ConfigurationFile.ini 3.ConfigurationFile.ini ***Get config file from GUI installation(before finish install step) you can see the "ConfigurationFile.ini" file location in C drive.then copy it modify below *** Do modify below ACTION="Install" IACCEPTSQLSERVERLICENSETERMS = "true" ;UIMODE="Normal" QUIET="true" ;QUIETSIMPLE="true" FEATURES=**select which feature you wnat*****
17 People are following this question.
