SQL本地管理员用户及新建授权用户输入密码无法登录,且sa被禁用时解决方法,前提条件是要知道SA用户登录密码。
运行输入CMD,找到SQL安装包文件目录
DOS输入cd D:
方法一、
start/wait "D:\Software\Microsoft SQL SERVER 2008\Microsoft SQL SERVER2008\setup.exe" /qn INSTANCENAME="MSSQLSERVER"REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=@goldenladies
start/wait L:\Servers\setup.exe /qn INSTANCENAME="MSSQLSERVER"REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=www_yongfa365_com
setup.exe/QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQL2008/SQLSYSADMINACCOUNTS="WWW-CC04E3DA6C9\Administrator" /SAPWD=yjj
方法二、
start /wait "D:\Software\Microsoft SQL SERVER2008\Microsoft SQL SERVER 2008\setup.exe" /qnINSTANCENAME="MSSQLSERVER" REINSTALL=SQL_Engine REBUILDDATABASE=1SAPWD=@goldenladies
start /wait .\setup.exe /qnINSTANCENAME="MSSQLSERVER" REINSTALL=SQL_Engine REBUILDDATABASE=1SAPWD=@goldenladies