February 27, 2006 at 7:55 am
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.
February 27, 2006 at 8:04 am
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
February 27, 2006 at 8:24 am
Hey, SQLBill. Thanks for the reply. I did check the logs...event logs and SQL logs. Nothing there. Any other ideas? Thanks.
February 27, 2006 at 12:06 pm
Did you check to see if the DNS server was down at the time it failed?
-SQLBill
February 28, 2006 at 8:29 am
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.
February 28, 2006 at 9:33 am
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