Monday, March 26, 2012

Error 8198: Unable to determine if the owner has server access...

We recently converted our NT 4 domain to Active Directory, and jobs started
failing with messages like the following. Evidently, SQL Server is having
trouble verifying the credentials of the job owner:
The job failed. Unable to determine if the owner (<Domain>\<user> ) of job
<JobName> has server access (reason: Could not obtain information about
Windows NT group/user (<Domain>\<user> ) '. [SQLSTATE 42000] (Error 8198)
).
I see there are KB articles talking about pre-2000 compatibility, but both
the domain controller and the SQL Server machine are running Windows Server
2003. Does anyone know how to fix this?
(Yes, you can change the job owner as a workaround, but this won't keep
future jobs from being owned by Windows users unless we switch everyone over
to SQL authentication)
Thanks.Check this kb;
825042 FIX: SQL Server Jobs That Are Owned by Non-sysadmin Users May Not
Start
http://support.microsoft.com/?id=825042
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment