如何在 SQL Server 2005 Management Studio 中解锁用户帐户？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1477539/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to unlock user account in SQL Server 2005 Management Studio?
提问by gbn
One of user name tried login many times and failed. Sql server 2005 locked account automatically. How can I unlock user account in SQL Server 2005 Management Studio?
其中一个用户名尝试登录多次失败。Sql server 2005 自动锁定帐户。如何在 SQL Server 2005 Management Studio 中解锁用户帐户？
回答by gbn
Bug via SSMS in SQL 2005. Only SQL 2008
SQL 2005 中通过 SSMS 出现的错误。仅 SQL 2008
I assume you know the password or can reset it. From BOL, ALTER LOGIN
我假设您知道密码或可以重置密码。从 BOL，更改登录
ALTER LOGIN foo WITH PASSWORD = '<enterStrongPasswordHere>' UNLOCK
回答by Tao
Tip/workaround from http://www.sqldbadiaries.com/2010/07/21/unlock-sql-user-without-changing-the-password/#ixzz2OBIJCsqv
来自http://www.sqldbadiaries.com/2010/07/21/unlock-sql-user-without-changed-the-password/#ixzz2OBIJCsqv 的提示/解决方法
ALTER LOGIN sqluser WITH CHECK_POLICY = OFF;
ALTER LOGIN sqluser WITH CHECK_POLICY = ON;
GO
回答by TLiebe
Open Server Management Studio, connect to the server and go to the Security --> Logins item in Object Explorer. Select the login that is locked out and double-click on it. The Status page should let you re-enable the login (uncheck the "Login is locked out" box).
打开 Server Management Studio，连接到服务器并转到对象资源管理器中的安全 --> 登录项。选择被锁定的登录名并双击它。状态页面应该让您重新启用登录（取消选中“登录被锁定”框）。
