January 15, 2009 at 2:01 am
Hi all,
few days before the development team was working with sql server 2005 , every thing was fine but after some time they were not able to connect to the DB. After figuring out the reason we came on conclusion that the 'sa' account is got locked . So i want to know the possible reasons for getting a account locked..
Thanks
Saurabh
January 15, 2009 at 2:19 am
First I'd like to ask why your developers use the sa account ? That's very bad practice and I would never allow that.
The reason the account is locked is that by default in SQL 2005 the password policy applies to the all SQL logins including "sa". So after too many successive failed logins, the account get's locked. If you check the SQL errorlog you should see several failed login attempts before the account got locked.
[font="Verdana"]Markus Bohse[/font]
January 15, 2009 at 7:59 am
I'd also be concerned someone else is trying to hack into the server.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply