On Sunday, July 22, 2012 1:04:27 PM UTC-4, Scott wrote:
Quote:
Microsoft's documentation is incomplete. It tells you how to install sql server from the command line from the command line. It only tells you how to add features from the GUI. I need to add reporting services using the command line!
Any clues?
Thanks Scott |
The answer is use the install action with the new features included. I tried this on my sql server installation and it seems like it would work, except I was trying to add reporting services and the web edition does not include that feature.
setup.exe /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION=install /PID=<validpid> /FEATURES=SQL,AS,RS,IS,Tools
/INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="MyDomain\MyAccount"
/SQLSVCPASSWORD="************" /SQLSYSADMINACCOUNTS="MyDomain\MyAccount "
/AGTSVCACCOUNT="MyDomain\MyAccount" /AGTSVCPASSWORD="************"
/ASSVCACCOUNT="MyDomain\MyAccount" /ASSVCPASSWORD="************"
/RSSVCACCOUNT="MyDomain\MyAccount" /RSSVCPASSWORD="************"
/ISSVCAccount="MyDomain\MyAccount" /ISSVCPASSWORD="************"
/ASSYSADMINACCOUNTS="MyDomain\MyAccount"
source [http://measureofchaos.blogspot.com/2...-command.html]