Error Message

  • Any of you ever seen the message below?

     

    "MESSAGES: The job failed. Unable to determine if the owner (Domainname\username) of job "jobname" has server access (reason: Could not obtain information about Windows NT group/user 'Domainname\username'. [SQLSTATE 42000] (Error 8198))."

    Any idea of what's causing it?  The logs don't say anything.  What can I do to prevent it from happening again?  Thanks.

  • Have you checked the Windows Event Viewer Logs? Usually when a Windows Authenticated user cannot connect, it is:

    1. the login is SQL Server Authentication - which doesn't apply in this case

    2. the DNS server is 'down' or not reachable by the SQL Server.

    I'm guessing the DNS server was unreachable.

    -SQLBill

  • Hey, SQLBill.  Thanks for the reply.  I did check the logs...event logs and SQL logs.  Nothing there.  Any other ideas?  Thanks.

  • Did you check to see if the DNS server was down at the time it failed?

    -SQLBill

  • DNS Server problems.  From time to time we get the same error.  This is a fun one for your network guys to try and troubleshoot because it doesn't consistently happen.

  • Thanks, guys.  I'll alert our network manager.  Again, thanks.

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

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