Results 1 to 2 of 2

Thread: SQL Server Agent Error- Urgent

  1. #1
    Cynthia Guest

    SQL Server Agent Error- Urgent

    Hi,
    I have question. My SQL Server Agent Log has the following error messages logged. Does anyone know why this happens. It happens everyday when I back up a 40 GB Database. Let me know. I Appreciate the help.

    Thanks,
    Cynthia

    6/14/01 9:30:58 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:30:59 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:31:01 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:30:58 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:30:59 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:31:00 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:31:01 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:31:02 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:31:03 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
    6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
    6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)

    6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
    6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)

  2. #2
    eddie Guest

    SQL Server Agent Error- Urgent (reply)

    I would check the user the Agent is trying to use and also if any other logon errors for the agent. Does it use the system account or a domain or machine user? If it logs on elsewhere OK - then there may be something else wrong here, if it can't access the DB anywhere (try a manual startup and see) then this may be the issue.


    ------------
    Cynthia at 6/15/01 1:41:02 PM

    Hi,
    I have question. My SQL Server Agent Log has the following error messages logged. Does anyone know why this happens. It happens everyday when I back up a 40 GB Database. Let me know. I Appreciate the help.

    Thanks,
    Cynthia

    6/14/01 9:30:58 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:30:59 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:31:01 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:30:58 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:30:59 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:31:00 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:31:01 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:31:02 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:31:03 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
    6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
    6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
    6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)

    6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
    6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •