jasonashworth
Technical User
Strange one, this... When the OS (NT4) starts on the server, it is supposed to start SQL Server and SQL Agent (SQL v7.0, SP3). However, SQL Agent fails to start, and writes this to the sqlagent.out file:
23/11/01 10:15:29 - ? [129] SQLServerAgent starting under Windows NT service control
23/11/01 10:17:35 - ! [298] SQLServer Error: 11, General network error. Check your network documentation. [SQLSTATE 08S01]
23/11/01 10:17:35 - ! [298] SQLServer Error: 10054, ConnectionWrite (send()). [SQLSTATE 01000]
23/11/01 10:17:35 - ! [000] Unable to connect to server; SQLServerAgent cannot start
23/11/01 10:17:35 - ? [098] SQLServerAgent terminated (normally)
If you then try to manually start SQL Agent, it works fine... I could probably use an xp_cmdshell to start it automatically once SQL Server has started, but that's more of a workaround than a fix... Any ideas??
Cheers,
Jason.
23/11/01 10:15:29 - ? [129] SQLServerAgent starting under Windows NT service control
23/11/01 10:17:35 - ! [298] SQLServer Error: 11, General network error. Check your network documentation. [SQLSTATE 08S01]
23/11/01 10:17:35 - ! [298] SQLServer Error: 10054, ConnectionWrite (send()). [SQLSTATE 01000]
23/11/01 10:17:35 - ! [000] Unable to connect to server; SQLServerAgent cannot start
23/11/01 10:17:35 - ? [098] SQLServerAgent terminated (normally)
If you then try to manually start SQL Agent, it works fine... I could probably use an xp_cmdshell to start it automatically once SQL Server has started, but that's more of a workaround than a fix... Any ideas??
Cheers,
Jason.
