SQL server Agent - Not starting - Automatic start enabled
- by user130561
SQL server agent is not starting automatically even when it is set to "Automatic". We have a weekend reboot of the server and usually it should come up automatically since it is set to "Automatic".
SQL Agent Logs:
[298] SQLServer Error: 831, Client unable to establish connection [SQLSTATE 08001]
[382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
[165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]