locked
SQL Server 2005 Agent Logs RRS feed

  • Question

  • Hi,

    I am getting below erros in SQL Agent:

    Please help me to solve.

    2011-03-24 00:38:38 - ! [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
    2011-03-24 00:38:38 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
    2011-03-24 00:38:38 - ! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
    2011-03-24 00:38:38 - ! [382] Logon to server '(local)' failed (ConnUpdateStartExecutionDate)
    2011-03-24 00:44:09 - ! [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
    2011-03-24 00:44:09 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
    2011-03-24 00:44:09 - ! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
    2011-03-24 00:44:09 - ! [382] Logon to server '(local)' failed (ConnUpdateJobActivity_NextScheduledRunDate)
    2011-03-24 00:44:55 - ! [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
    2011-03-24 00:44:55 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
    2011-03-24 00:44:55 - ! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
    2011-03-24 00:44:55 - ! [382] Logon to server '(local)' failed (ConnUpdateStartExecutionDate)
    2011-03-24 00:45:25 - ! [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
    2011-03-24 00:45:25 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
    2011-03-24 00:45:25 - ! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
    2011-03-24 00:45:25 - ! [382] Logon to server '(local)' failed (JobManager)
    2011-03-24 00:45:45 - ! [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
    2011-03-24 00:45:45 - ! [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
    2011-03-24 00:45:45 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
    2011-03-24 00:45:45 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
    2011-03-24 00:45:45 - ! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
    2011-03-24 00:45:45 - ! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
    2011-03-24 00:45:45 - ! [382] Logon to server '(local)' failed (ConnUpdateStartExecutionDate)
    2011-03-24 00:45:45 - ! [382] Logon to server '(local)' failed (ConnUpdateStartExecutionDate)
    2011-03-24 00:46:00 - ! [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
    2011-03-24 00:46:00 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
    2011-03-24 00:46:00 - ! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
    2011-03-24 00:46:00 - ! [382] Logon to server '(local)' failed (JobManager)
    2011-03-24 00:46:15 - ! [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
    2011-03-24 00:46:15 - ! [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
    2011-03-24 00:46:15 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
    2011-03-24 00:46:15 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
    2011-03-24 00:46:15 - ! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
    2011-03-24 00:46:15 - ! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
    2011-03-24 00:46:15 - ! [382] Logon to server '(local)' failed (JobManager)
    2011-03-24 00:46:15 - ! [382] Logon to server '(local)' failed (JobManager)
    2011-03-24 00:48:44 - ! [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
    2011-03-24 00:48:44 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
    2011-03-24 00:48:44 - ! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
    2011-03-24 00:48:44 - ! [382] Logon to server '(local)' failed (ConnUpdateStartExecutionDate)
    2011-03-24 00:49:00 - ! [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
    2011-03-24 00:49:00 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
    2011-03-24 00:49:00 - ! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
    2011-03-24 00:49:00 - ! [382] Logon to server '(local)' failed (ConnUpdateJobActivity_NextScheduledRunDate)
    2011-03-24 00:49:14 - ! [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
    2011-03-24 00:49:14 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
    2011-03-24 00:49:14 - ! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
    2011-03-24 00:49:14 - ! [382] Logon to server '(local)' failed (JobManager)
    2011-03-24 00:49:49 - ! [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
    2011-03-24 00:49:49 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
    2011-03-24 00:49:49 - ! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
    2011-03-24 00:49:49 - ! [382] Logon to server '(local)' failed (JobManager)
    2011-03-24 00:54:25 - ! [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
    2011-03-24 00:54:25 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
    2011-03-24 00:54:25 - ! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
    2011-03-24 00:54:25 - ! [382] Logon to server '(local)' failed (ConnUpdateJobActivity_NextScheduledRunDate)
    2011-03-25 00:40:13 - ! [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
    2011-03-25 00:40:13 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
    2011-03-25 00:40:13 - ! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
    2011-03-25 00:40:13 - ! [382] Logon to server '(local)' failed (ConnUpdateJobActivity_NextScheduledRunDate)
    2011-03-25 00:43:02 - ! [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]
    2011-03-25 00:43:02 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]
    2011-03-25 00:43:02 - ! [298] SQLServer Error: 258, Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
    2011-03-25 00:43:02 - ! [382] Logon to server 'SQLMB' failed (ConnAttemptCachableOp)

     

    Friday, March 25, 2011 3:21 PM

Answers

  • HI,

    Ya you are right. But i am looking for root cause and resolution.

    Hi Vijay,

    From the error message it appears that the SQL Server Agent was unable to connect to the SQL Server Instance. The Instance must have been busy. You would need to check the Error Log\System Log\Application Log for possible error messages. 




    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @PradeepAdiga

    • Proposed as answer by WeiLin Qiao Wednesday, March 30, 2011 7:17 AM
    • Marked as answer by WeiLin Qiao Monday, April 4, 2011 2:03 AM
    Saturday, March 26, 2011 4:05 PM

All replies

  • It looks to me as if the SQL Server Service has stopped.
    Peter Carter-Greenan http://sqlserverdownanddirty.blogspot.com/
    Friday, March 25, 2011 11:05 PM
  • HI,

    Ya you are right. But i am looking for root cause and resolution.

    Saturday, March 26, 2011 3:10 AM
  • Ok, if you look in the Windows event log, then you should see an error from when the service stopped, that will hopefully give some further information.
    Peter Carter-Greenan http://sqlserverdownanddirty.blogspot.com/
    Saturday, March 26, 2011 9:19 AM
  • HI,

    Ya you are right. But i am looking for root cause and resolution.

    Hi Vijay,

    From the error message it appears that the SQL Server Agent was unable to connect to the SQL Server Instance. The Instance must have been busy. You would need to check the Error Log\System Log\Application Log for possible error messages. 




    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @PradeepAdiga

    • Proposed as answer by WeiLin Qiao Wednesday, March 30, 2011 7:17 AM
    • Marked as answer by WeiLin Qiao Monday, April 4, 2011 2:03 AM
    Saturday, March 26, 2011 4:05 PM
  • Hi,

    But we have not found any errors in Application/System Log

    Saturday, December 28, 2013 8:11 PM