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

I got message on running application as follows

run-time error - 2147467259
login failed for user 'sa' because account is currently locked out. The system administrator can unlock it.

I have 3 database on server but only one database it is giving error,

Thanks in Advance.

Nitin
Nitin ShahAsked:
Who is Participating?

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

x
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.

arnoldCommented:
The error is given on the database to which SA credentials are in use.
The other databases might be using other credentials.  
Depending on your setup, it seems that you may have account lockout policy in place and the SA user login attempts have exceeded that treshhold locking the account for the duration set in the password handling Policy.

Possible cause is user/systems on the LAn attempted to gain access to the sql server using the SA.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
I have 3 database on server but only one database it is giving error,
Did you want to mean 3 Instances instead of 3 databases?

There's any other user with SA permission? If not, ask to your system administrator to change the Account Lockout Policy on the Local Security Policy (gpedit.msc).
0
Nitin ShahAuthor Commented:
No all database have user 'sa'.  but my problem solved after re-installing sql server.

Thanks

Nitin
0
arnoldCommented:
While it is common for some to go the reinstall route, one learns nothing from that experience while risking a significant catastrophe.

It is unnecessary to reinstall something that is not broken. My guess is that the lockout period ended by the time the reinstall completed and a reinstall does not and will not resolve the underlying issue that led to the lockout of the account.

Often the administrative user given sql login is only available in a mix mode configuration and provided the person remembered to add administrative account/accounts to the sql server (they can but do not necessarily have to be administrative on the server or the domain).
Using SSMS by the SQL Administrative windows account, you can connect to the database and unlock the sa account after determining the source of requests that led to its lockout and dealing with the ............. i.e. a compromised system with a virus that attacked your sql server .......
0

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
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.