SQL Server 2008 R2上的用户sa登录失败 [英] login failed for user sa at SQL Server 2008 R2

问题描述

升级到Service Pack 1后，有时我无法登录服务器

After upgrading to Service Pack 1, sometimes i got failed to login my server

这时，服务器配置管理器如下所示

at this time, Server Configuration Manager is like below

我需要更改任何内容吗?谢谢.

Do I need to change anything? thank you.

-

一旦我可以登录，服务器配置管理器将如下所示

Once I could login, Server Configuration Manager is like below

在故障期间，我尝试启动"SQL Server(MSSQLSERVER)"，但启动失败.我的R2 Express有什么问题?请把你的想法分享给我.

During the failure time, I try to start "SQL Server (MSSQLSERVER)" but got fail to start. What is wrong in my R2 express? Please share me your idea.

运行"SQL Server(MSSQLSERVER)"后，我可以以"sa"身份登录到我的服务器.

After running "SQL Server (MSSQLSERVER)", I could login in to my server as 'sa'.

推荐答案

尽管下面的快照提到了SQL Server 2008/express，但我还是建议检查以下几点.

Although my below snaps mention SQL Server 2008/express I would suggest to check for the below points.

• 检查是否需要在数据库名称之前添加本地计算机名称前缀

• Check whether you need to put the local computer name prefix before your DB name

如果使用Windows身份验证与创建数据库实例时创建的帐户进行连接，则可以右键单击数据库->数据库属性并选择以下安全性选项来进行故障排除.

If you connect using Windows authentication with the account you've created when you create your DB instance you can troubleshoot with right click database --> Database properties and select the below security option.

双击安全选项下的sa登录.您可以按以下要求更改密码.

Check sa login under security option by double clicking. You can change the password if required as below.

此外，如果您在同一属性视图上看到 USER MAPPING (用户映射)选项，请选中该选项并确保将sa选中要登录的数据库.

Also if you see USER MAPPING option on the same properties view, check it and makesure sa is checked into the database you want to login.

• 重新启动SQL Server服务(快捷方式:Winkey + R，然后按services.msc)

• 尝试再次登录，祝你好运！

这篇关于SQL Server 2008 R2上的用户sa登录失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！