SQL SERVER 2005 sa登录失败!

1. 用Windows身份验证登陆(这个应该是不会存在问题的, 在新安装好实例(SQL Server)的情况下, Windows身份验证是不可能被禁用的(安装过程中没有可以设置禁用Windows身份验证的地方)
   Manage Studio -- 菜单"文件"--"连接对象资源管理器", 身份验证中选择"Windows Authentication"

2. 连接成功后, 右键你的实例, 选择"属性"

3. 在"属性"窗口中, 转到"Security"(安全性)项, 在"服务器身份验证"中设置为"SQL Server和Windows身份验证模式", 确定, 根据提示, 你应该重新启动sql服务

4. 重新启动sql服务后, 照用Windows身份验证连接, 然后执行下面的语句启用sa用户, 同时清除sa的密码(能成功登陆后再根据你的需要设置)

EXEC sp_password null,null,'sa' //如果不行就设个密码EXEC sp_password null,'123456','sa'

ALTER LOGIN sa ENABLE

5. 语句执行完成后, 再用sa连接你的实例, 应该就没有问题了.

 

The sa login can only connect to the server by using SQL Server Authentication.

To change security authentication mode

---

1. In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.

2. On the Security page, under Server authentication, select the new server authentication mode, and then click OK.

3. In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.

To restart SQL Server from SQL Server Management Studio

---

1. In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted.

To enable the sa login by using Transact-SQL

---

1. Execute the following statements to enable the sa password and assign a password.

   ALTER LOGIN sa ENABLE ;GOALTER LOGIN sa WITH PASSWORD = '<enterStrongPasswordHere>' ;GO

To enable the sa login by using Management Studio

---

1. In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties.

2. On the General page, you might have to create and confirm a password for the sa login.

3. On the Status page, in the Login section, click Enabled, and then click OK.

   本文转自loose_went博客园博客，原文链接：http://www.cnblogs.com/michaelxu/archive/2009/07/28/1533507.html ，如需转载请自行联系原作者