2

Can anyone confirm under what circumstances a SQL Server windows login account changes from Enabled to Disabled?

More specifically does this need to be a human interaction or can SQL Server automatically disable a windows account under some circumstances (say if it connects too frequently?)

I do not have access to the SQL Server logs so I can't check these

We have many SSIS jobs running against many SQL Servers under a service account. We discovered yesterday that the windows account was disabled on one source server (but still functions against many other servers)

Update: its possible this account was not disabled but I'm still interested in the answer.

  • 1
    Only a human intervention can change it or query which was running as part of some process it cannot do by its own. See errorlogs you would get information there – Shanky Feb 24 '15 at 4:45
  • Thanks. I don't have access to error logs but that clarifies it for me. Do you want to put that as an answer – Nick.McDermaid Feb 24 '15 at 7:00
1

SQL Server never automatically disables any account. Only a human intervention can do that....

Probably you could put a request for your DBA to provide error logs for the timings you wanted....and you could find the info from the logs....

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.