2

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

6
  • Well, If the above is a copy paste from what you are using, I suspect you may have had a few syntactical errors. Firstly, remove the space between the "=" and "Install". Also "IACCEPTSQLSERVERLICENSETERMS" has no spaces.
    – RoKa
    Mar 28, 2013 at 9:25
  • You can also add the /INDICATEPROGRESS parameter to pipe a verbose log to the console.
    – RoKa
    Mar 28, 2013 at 9:27
  • how to pipe a verbose log to the console?
    – Navaneet
    Mar 28, 2013 at 11:04
  • Hi. You would need to add the /INDICATEPROGRESS parameter 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".
    – RoKa
    Mar 28, 2013 at 12:40
  • For e.g. your command line will become "D:\SQLEXPR32_x86_ENU (1).exe" /q /ACTION=Install /FEATURES=SQL /INSTANCENAME=nvt /SECURITYMODE=SQL /sapwd=abc /IACCEPTSQLSERVERLICENSETERMS /INDICATEPROGRESS >c:\temp\log.txt".
    – RoKa
    Mar 28, 2013 at 12:42

1 Answer 1

1

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.