locked
Error ID 208 Unable to Determine if the Owner has Server Acccess RRS feed

  • Question

  • Hi - We are running SQL 2008 Standard and have an issue that I need help resolving.   When I try some items such as the DBCC I get an Error ID 208  with the description -   "Unablel to determine if the owner (domin\Administrator) of job BMC: Check Integrity (database name) has server access (reason: Could not obtain information about Windows NT group/user 'DOMAIN\Administrator', error code 0x5. [SQLSTATE 42000] (Error 1504)).

    Thanks! for the assist -  NC Beach Bum


    NC Beach Bum
    Friday, October 22, 2010 3:19 PM

Answers

  • Check the job owner in job properties. Change it to sa as work around.
    0x5 mean access denied.
    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    • Marked as answer by Tom Li - MSFT Tuesday, November 2, 2010 8:21 AM
    Friday, October 22, 2010 3:46 PM

All replies

  • There are likely more errors in the Windows event log. It looks like SQL Server can't reach the domain controller to find domain permissions.
    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty
    Friday, October 22, 2010 3:37 PM
  • Check the job owner in job properties. Change it to sa as work around.
    0x5 mean access denied.
    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    • Marked as answer by Tom Li - MSFT Tuesday, November 2, 2010 8:21 AM
    Friday, October 22, 2010 3:46 PM