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?
A:
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).
TLiebe
2009-09-25 14:16:10
A:
Bug via SSMS in SQL 2005. Only SQL 2008
I assume you know the password or can reset it. From BOL, ALTER LOGIN
ALTER LOGIN foo WITH PASSWORD = '<enterStrongPasswordHere>' UNLOCK
gbn
2009-09-25 15:22:30