September 23, 2001 at 10:19 pm
I use the SQL Maintenance Plan to generate DB and Trans Logs dumps. The job runs under the authority of the “Admin” account. Generally, the process works fine but occasionally we get:
“The Job Failed. Unable to determine if the owner (<domain name>\Admin) of Job Transaction Log Backup Job for DB maintenance Plan “<machine name> Backup Plan” has server access (reason: Could not obtain information about Windows NT group/user <domain name>\Admin [SQLSTATE 42000] Error 8198).
In other words, NT authentication seems to fail. Anyone had the same experience? Any ideas what’s going on?
TIA,
Bill Salkin
September 24, 2001 at 4:09 pm
Take a look at this article:
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q241643
Andy
September 25, 2001 at 10:31 am
I see this occassionly on my W2K/SS2K server. Actually I had it the last two nights. The server is across a slow link fro the domain and it seems to have problems reaching the domain controller at times. I don't have a solution other than reboot and force a new authentication to the domain controller.
Keep in mind that if your plan accesses resources off the local machine, security credentials are checked with the domain controller. This is a real-time authenticaiton.
Steve Jones
October 21, 2002 at 3:16 pm
Does anybody have any new information about this issue? I am experiencing it - and my network guys claim nothing has changed regarding our domain controller - and my server hasn't changed. Yet friday everything worked Ok, and now I get this error message.
I checked the microsoft knowledge base - the one article doesn't apply to my situation as I have 2000 server checking against an NT PDC.
I can't find much in the way of 'how' sql server accesses the NT verification system, b/c I think that is where the problem is.
October 21, 2002 at 4:10 pm
Could you try a static lmhosts file for the pdc so the server knows where to go.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply