SQL Server Agent Stops Unexpectedly and does not restart
Posted on 2010-09-13
I am running SQL Server 2008 (10.0.2531) 32 bit on a 4 CPU Dual Core HP Server with 64GB of RAM. AWE is enabled.
The SQL Server Agent service is running under a purpose designed Network account and is set to
auto-restart on first failure, auto-restart on second failure and restart the whole server on third failure.
Just before the SQL Agent stops, the error log provides the following error messages:
1. SQLServer Error: 258, TCP Provider: Timeout error . [SQLSTATE 08001]
2. ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
3. SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
4. Logon to server '(local)' failed (SubSystemStepHistoryLogger)
and then nothing, until the server is restarted manually.
The windows event logs provide no help.