Take the 2-minute tour ×
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's 100% free, no registration required.

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

share|improve this question
    
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 '13 at 9:25
    
You can also add the /INDICATEPROGRESS parameter to pipe a verbose log to the console. –  RoKa Mar 28 '13 at 9:27
    
how to pipe a verbose log to the console? –  Navaneeth Mar 28 '13 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 '13 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 '13 at 12:42

1 Answer 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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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