开发者

cmd line SQL server 2008 express install

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" /S开发者_如何学GoQLSVCACCOUNT="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


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 


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.


You can set the correct arguments by using the ConfigurationFile.ini file in which been created when you go through the normal SQL Server setup procedure in last step before installing. Just copy the path of this file which appears below the screen and copy/paste the configuration arguments you need.

You'll notice that the SQLSYSADMINACCOUNTS argument been set to your local administrator account, replace it like this 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"
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜