SQL Login failed because the account is currently locked out

Posted At : 30 April 2007 10:27 | Posted By : Duncan Loxton
Related Categories: SQL

[Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'databasename01' because the account is currently locked out. The system administrator can unlock it.

Scary stuff. However its easy to fix.

For example if we are using databaseuser01 to access this database simply run

alter login databaseuser01 with password='S0meR4nd0mPwd' unlock

this has something to do with SQL enforcing a password policy on the user, however I don't know the details.

Comments (2) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 1075 Views
Comments
[Add Comment]
Ramakrishna Raju's Gravatar Very Informative Post, Thanks a Lot.
# Posted By Ramakrishna Raju | 01/10/07 17:24
Umesh's Gravatar Really good one
# Posted By Umesh | 19/11/07 22:48
[Add Comment]
BlogCFC was created by Raymond Camden. This blog is running version 5.9.001.