cmd line SQL server 2008 express install

Question

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.

Answer 1

I think it will work if you use the 'domain' qualified Administrators account name instead of the generic moniker. Eg. like <hostname>\Administrators where is the machine name where the instance is installed (since is the name of the NT domain in this case).

If it doesn't work, you can always run the setup with current user under /SQLSYSADMINACCOUNTS and have a post-setup step that adds the local administrators to sysadmin.

Answer 2

I use thes and it work.

Setup.exe /q /ACTION=Install /SkipRules=VSShellInstalledRule RebootRequiredCheck /HIDECONSOLE /FEATURES=SQL /INSTANCENAME=xxx /SECURITYMODE="SQL" /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SAPWD="XXXXXXXXX" /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /ENABLERANU=1 /AGTSVCACCOUNT="NT AUTHORITY\SYSTEM" /TCPENABLED=1 /ERRORREPORTING=1