We help IT Professionals succeed at work.

SQL Server 2008 r2- Login failed for user 'sa' - account is currently lock

I have a application using SQL Server 2008 r2 database.
I have three database. but in  one of the databases it is giving error as follows

Run-time error - 2147467258
SQL server login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it.

Thanks in advance

Nitin
Comment
Watch Question

Senior Developer
Commented:
Well, then the administrator should unlock the sa account.

E.g.

ALTER LOGIN [sqldbpool] WITH PASSWORD = 'password' UNLOCK

Open in new window


btw, under most circumstances, it's imho not a good idea to use the sa account at all.

p.s. the interesting question here is, how got the account locked?
Top Expert 2012

Commented:
The author has posted this as a duplicate question and it should be deleted.

Post comments here:
http://www.experts-exchange.com/Database/MS-SQL-Server/SQL_Server_2008/Q_28641440.html

Author

Commented:
really easy solution.  after solving the problem i have re-install sql server.
 The problem has been solved.

Thanks