cmd line SQL server 2008 express install

Posted by Balaram on Stack Overflow See other posts from Stack Overflow or by Balaram
Published on 2010-04-14T20:43:09Z Indexed on 2010/04/14 22:53 UTC
Read the original article Hit count: 195

Filed under:

hi,

I am trying to install SQL server 2008 express on windows 7 64 bit machine using the following command:

Setup.exe /qs /Action=Install /Features=SQL /InstanceName=XXX /SQLSYSADMINACCOUNTS="Builtin\Administrators" /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM"

I can not access the database and get "access denied" error. I narrowed down the issue to the /SQLSYSADMINACCOUNTS="Builtin\Administrators" parameter not working. When I change this parameter value to currnet user or try manual install it works

Any idea is appreciated.

© Stack Overflow or respective owner

Related posts about sql-server