Login failed for user 'sa'. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)
我使用的是SQL Server 2008 R2
1. 以windows authentication身份登陆
2. Security-->logins-->sa-->properties-->general-->修改密码
3. Properties-sa -->status--> login:enabled
4. 成功
参考文献:http://www.mytechmantra.com/LearnSQLServer/change-sa-password-in-SQL-Server.html