Search

Friday, December 9, 2011

Login failed for user ‘sa’ because the account is currently locked out. The system administrator can unlock it.

Today I got the error in one system.
"Login failed for user ‘sa’ because the account is currently locked out. The system administrator can unlock it."


the main cause of this error is 
"SQL Account only locked out, if it is enfoced to use password policies."





To solve this error run the below query:
ALTER LOGIN sa WITH PASSWORD = ‘password’ UNLOCK
We can aslo do this from GUI

No comments:

Post a Comment