Why can I not unlock a SQLServer User?
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ooo, ooo, ooo, SSMS, so bad.
Got it. In a round about way. I unchecked "enforce" password policy, then unchecked "Lock out", then OK. Then it worked. I then went back in and rechecked "enfore..."
Got it. In a round about way. I unchecked "enforce" password policy, then unchecked "Lock out", then OK. Then it worked. I then went back in and rechecked "enfore..."
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you gentlemen!
For those that follow
The workaround is in comment: 07/09/09 12:09 PM, ID: 24815778
The explanation for the workaround is from rob_farley (07/09/2009 - 09:52PM CDT).
Thanks!!
For those that follow
The workaround is in comment: 07/09/09 12:09 PM, ID: 24815778
The explanation for the workaround is from rob_farley (07/09/2009 - 09:52PM CDT).
Thanks!!
ASKER