login is locked out

[katekis]

I am using Managment Studio and I am trying to change a password for a user. The status on the user says it is locked. I unlock it and reset the password but then minutes latter when I check it, it is locked again. Below is the sql I am using.

alter login MiserSAM with password ='xxxxxxxxx' unlock

Why can I not get this to stay unlocked?

 

[hmckillop]

It sounds like someone or something (e.g. app) has an active connection and is retrying the login with old password and causing it to lock out.
Try profiling the DB capturing logins and then you will see where it originates from.



"I'm living so far beyond my income that we may almost be said to be living apart

 

[SQLBill]

Have the user COMPLETELY log out of all their open SQL Server connections. If they have even one open with the wrong/old password then that will lock their account as it continues to try and make a connection.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875