Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I am using following command line to install SQL Server 2008 R2 but its not installing. Also, I am not getting any error or log in summary.txt.
"D:\SQLEXPR32_x86_ENU (1).exe" /q /ACTION= Install /FEATURES=SQL/INSTANCENAME=nvt /SECURITYMODE=SQL /sapwd=abc/IACCEPTSQLSERVERLICENSETERMS
I've found this blog, and the solution the author described works like a charm for me.
Below is command line install command
setup.exe /QUIETSIMPLE /ACTION=install /FEATURES=SQL /INSTANCENAME=SQL2008
/SQLSVCACCOUNT=”NT Authority\System” /SQLSYSADMINACCOUNTS=”sreekanthpc\sreekanth”
/AGTSVCACCOUNT=”NT Authority\System” /SECURITYMODE=SQL /SAPWD=”Pa$$w0rd”
/SQLTEMPDBDIR=”D:\SQL2008\TempDB\\” /SQLUSERDBDIR=”D:\SQL2008\SQLData\\”
/SQLUSERDBLOGDIR=”D:\SQL2008\SQLLog\\”
I hope this helps
/INDICATEPROGRESSparameter to your command line. If you would like to add all the console contents to a text file, you could add"> yourtextfile.txt"to the end of your command line too. You may have to specify a file location to save the text file, for e.g."> c:\temp\sqlinstlog.txt"."D:\SQLEXPR32_x86_ENU (1).exe" /q /ACTION=Install /FEATURES=SQL /INSTANCENAME=nvt /SECURITYMODE=SQL /sapwd=abc /IACCEPTSQLSERVERLICENSETERMS /INDICATEPROGRESS >c:\temp\log.txt".