SQL Server Troubleshooting
Error 8198: Miscellaneous Agent: Job Failed. Unable to determine if
owner ... has server access ...
A miscellaneous agent has failed, the full error message being:
The job failed. Unable to determine if the owner (DDDD\UUUU)
of job JJJJ: distribution has server access (reason: Could not obtain
information about Windows NT domain\user 'DDDD'. [SQLSTATE 42000] (Error
The owner of the job (who is probably the user who created the job) does
not have the necessary permissions.
This error can also be generated when it is SQL Server Agent (or the
NT account within which it runs) does not have the necessary permissions
to obtain information about the specified user account. This can happen
when the SQL Server Agent account and the specified user account belong
to different domains.
Review whether the current owner of the job is appropriate. Then either:
- Grant the owner the necessary permissions.
- Change the owner to a more suitable account (for example use SQLServerAgent,
assuming that account was created when SQL Server was installed or an
account from within the same domain).
The owner of the job is shown under ‘Agent Properties’.
These notes are believed to be correct for SQL
Server 7 and may apply to other versions as well.
About the author: Brian Cryer
is a dedicated software developer and webmaster. For his day job he
develops websites and desktop applications as well as providing
IT services. He moonlights as a technical author and consultant.