For some reason, my windows domain account keeps getting locked. I have checked the event viewer and found that the sqlserv.exe is attempting to connect with my account. but i have checked all the sql server agent jobs and the services none of them are linked to my domain account. i am not sure what is causing this. It gets locked out in the odd timings where there when there is no backup or anything kind of activity happening at my end.
asked Feb 15 '12 at 03:36 PM in Default
If I ask myself when could be my windows account is locked, it should be when I try to supply the username and password. So the few possibilities could
Now, at the OS level, I am assuming that you have make sure that no where your password is saved OR no one/ application is using your user name and password.
At SQL Server level, I can think of only 3 scenarios when the credentials are supplied (there could be more)
For the first one, you can track down at OS level. For rest of the two, following script should help you out
If you found your username in the output, you may have find the root cause.
But also make sure nothing is happening at the OS level. This could be dangerous if someone is trying to use your username.
answered Feb 16 '12 at 02:48 PM
Are you leaving SSMS open?
I don't have the answer at hand but understanding the surrounding circumstances may help us troubleshoot further.
answered Feb 15 '12 at 06:25 PM
Can you profile the SQL Server to see if you can capture what is causing your account to be locked out? Just a thought...
answered Feb 15 '12 at 03:39 PM