question

UnishSQL avatar image
UnishSQL 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
sql-server-2008sqlserversql server 2008 r2sqlserver-2012
capture3.png (186.7 KiB)
configee.txt (796 B)
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Have you tried using QUIET="True" and IACCEPTSQLSERVERLICENSETERMS="True
0 Likes 0 ·
yes I have tried the both @sp_lock
0 Likes 0 ·
What about /Q when executing the setup from a command prompt?
0 Likes 0 ·
sqlaj 1 avatar image
sqlaj 1 answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

SQLDBA123 avatar image
SQLDBA123 answered
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*****
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.