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 ShahAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
Well, then the administrator should unlock the sa account.


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?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Anthony PerkinsCommented:
The author has posted this as a duplicate question and it should be deleted.

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

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.