SA account LOCKED OUT !

[Toepes]

When a user tried to access his MSSQL database he reveived this message:

Error: Unable to update database parameters: Try to establish connection failed: Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it..


He asked me to unlock: Now I have the same error and i can't find how to UNLOCK !

Can anyone help me ?

 

[Skeeter]

Try to use this command in cmd on your server:

osql -E -Q "ALTER LOGIN [user] DISABLE"

where user is the user name.

Or, posibly, this might be useful:

osql -E -Q "USE [master] GO grant CONNECT SQL TO [user] GO"

 

[kerpau]

mysql -P 8306 -u admin -p
use lockout;
delete from lockout where login='admin';

 

[IG0R]

Check your security local polices

adminstrative tools / local policies

find the option that block login after many attempts

maybe this can help you

 

[phillipmoo]

Today I have run into the same situation. I'm locked out of SQL Server and can't even log on with Windows Authentication. Luckily I find a program - SQL Server Password Changer, and it helps me unlock my locked sa account.

 

[Lee Woo]

you should uninstall and then reinstall