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.
Best Answer
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....