我不知道SA密码,所以我以单用户模式重新启动了我的SQL Server 2008标准版实例,希望能够更改SA密码。之后立即尝试连接,输入以下命令:
sqlcmd -S serverName\ss2008
,但出现以下信息:我试图直接更改密码,但失败了:Msg 18461, Level 14, State 1, Server serverName\SS2008, Line1 Login failed for user 'serverName\Administrator'. Reason: Server is in single user mode. Only one administrator can connect at this time.
请问“-m”真的代表零用户模式吗?还是我的服务器有严重问题?C:\Documents and Settings\Administrator>sqlcmd -U sa -z p@ssword Password: Msg 18470, Level 14, State 1, Server serverName, Line 1 Login failed for user 'sa'. Reason: The account is disabled.