Cmd string SQL Server 2008 express install
I am trying to install SQL Server 2008 express on a 64 bit Windows 7 machine using the following command:
Setup.exe / qs / Action = Install / Features = SQL / InstanceName = XXX / SQLSYSADMINACCOUNTS = "Builtin \ Administrators" / SQLSVCACCOUNT = "NT AUTHORITY \ SYSTEM"
I cannot access the database and get "access denied". I have narrowed down the problem to a parameter /SQLSYSADMINACCOUNTS="Builtin\Administrators"
that doesn't work. When I change this parameter value to currnet user or try to execute it manually, it works
a source to share
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
a source to share
I think it will work if you are using a qualified domain administrator account name rather than a generic nickname. For instance. for example <hostname>\Administrators
, where is the name of the machine where the instance is installed (since in this case the name of the NT domain).
If it doesn't work, you can always run the setup with the current user under / SQLSYSADMINACCOUNTS and follow the post-installation step that adds local administrators to the system administrator.
a source to share
You can set the correct arguments by using the ConfigurationFile.ini file that was created during the normal SQL Server installation in the last step before installation. Just copy the path to this file that appears below the screen and copy / paste the required configuration arguments.
You will notice that the argument has SQLSYSADMINACCOUNTS
been configured for your local administrator account, replace it with the following:SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS"
setup.exe /Action="Install" /QUIETSIMPLE="False" /ERRORREPORTING="True" /INDICATEPROGRESS="False" /INSTANCENAME="SQLEXPR2008" /FEATURES="SQLENGINE" /AGTSVCSTARTUPTYPE="Automatic" /ISSVCACCOUNT="NT AUTHORITY\NetworkService" /ASSVCSTARTUPTYPE="Automatic" /SQLSVCSTARTUPTYPE="Automatic" /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS"
a source to share