Agent Xps getting disabled automatically
I had a similar problem that I just resolved. Turned out, a new group policy had been applied to our server. This group policy disallowed domain users access to the D:, E:, &amp; F: drives. Our SQL Server Agent was configured to write out its error log to the E: drive. As the Log On account for the SQL Server Agent service was a domain based account, SQL Server Agent was now unable to write to its log file. It died immediately at service start up. It was very frustrating in that we saw nothing in the Windows Event Viewer other than that the service started up and then stopped.