SQL Server 2005 Sa Login Locked Out
Posted on 2009-04-30
Mixed Mode Authentication
Able to login with Window's account that's associated with Administrator's group on the box
Within Management Studio when right-clicking on sa, then selecting properties, and then status I can uncheck the 'Login is locked out' box and then click OK. I test out the login again and it states that the login is still locked out. Sure enough when I go back into the properties its states that its locked out. So I try a different approach, ALTER LOGIN sa WITH PASSWORD = 'xxx' UNLOCK and it completes successfully, but the results are the same, the account continues to be locked out. Any suggestions?