Why can I not unlock a SQLServer User?
Posted on 2009-07-09
I am the owner of my database and have remote desktop access to my virtual server (windows 2003) running SQL 2005. I had three bad login attempts on one of my users and I a trying to "Unlock" the user.
On the DB Server, in SSMS, I navigate to the User under the Security->Logins. I open the Properties of the user then select Status and I see "Login is locked out" checked. I uncheck it, go change the password in the "General" section and then click OK. No errors but when I go back into the Status of the user the user is still "Locked out".
Is there something else I have to change?