Jobs failing with event ID 208: Unable to determine if the owner (sa) of job has server access

  • The Warning in the NT Event log is:

      Source: SQLSERVERAGENT  Event ID:208

    SQL Server Scheduled Job 'Repliweb - 02 - Clear Load Status' (0x7945E683C07BBF4AA7FA5AD600FE50FE) - Status: Failed - Invoked on: 2004-06-18 03:00:00 - Message: The job failed. Unable to determine if the owner (sa) of job Repliweb - 02 - Clear Load Status has server access (reason: Unable to connect to server - check SQL Server and SQL Server Agent errorlogs).

    This job has been running fine every day for weeks. What has causes this? There have been no changes on our server. There are no other errors in the NT Event log or the SQL logs.

    Every other job failed in a similar way. Any clues?

     

  • Can it be related to this?

     

    http://support.microsoft.com/default.aspx?scid=kb;en-us;310882&sd=tech

  • I don't think so. This article describes error 208 having the folowing text "Server: Msg 208, Level 16, State 1, Line Invalid object name 'syslogins'." (which I don't see at all in my logs), and that this problem occurs during Log Shipping - something I don't do.

  • I have the same problem, Do you find any solution?

  • I would suspect a network outage of some sort.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply