cmd line SQL server 2008 express install

sql-server sql-server-2008-express

14,034

I use this and it works:

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

14,034

Balaram Palasamudrum

Updated on June 04, 2022

Comments

Balaram Palasamudrum almost 2 years

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
- SLaks about 14 years
  
  Is your user account in the Administrators group?
- Balaram Palasamudrum about 14 years
  
  yes, it is a member of Administrators group
- ctrlalt313373 over 12 years
  
  I'm getting this same issue too. SQL Server 2008 Express installs fine, but skips adding the users. Only seems to happen on Win7.
Balaram Palasamudrum about 14 years

Thanks for the reply. I tried <hostname>\Administrators, did not work. I tried to do post-setup using sqlcmd, it complains - user do not have permission to perform this action. Any idea?
Balaram Palasamudrum about 14 years

I still love to hear the real solution for this, but I resolved this issue by using parameter /SQLSYSADMINACCOUNTS="%USERDOMAIN%\Users", this is ok since the DB is used only by our app and does not raise any red flags from the users.