Saturday 3 January 2009

Agent Login Errors

Symptoms :
Agent Login Errors on a DPM 2007 box
4 errors, in this sequence, throughout the logs >

Date 03/01/2009 01:12:54
Log SQL Agent (Current - 11/25/2008 12:25:00 PM)
Message
[298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]

Date 03/01/2009 01:12:54
Log SQL Agent (Current - 11/25/2008 12:25:00 PM)
Message
[165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]

Date 03/01/2009 01:12:54
Log SQL Agent (Current - 11/25/2008 12:25:00 PM)
Message
[298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]

Date 03/01/2009 01:12:54
Log SQL Agent (Archive #2 - 05/01/2009 09:50:00)
Message
[382] Logon to server SERVERNAME\MS$DPM2007$' failed (SaveAllSchedules)

Actions Taken :
Disabling & Re-enabling TCP/IP & restarting SQL. Will monitor.

http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/c895335c-9a88-488c-b39c-f54fd6cceba9/

No comments: