SQL Jobs Fail With Error 8198
- Article Number: 000003807
- Products: Forcepoint DLP, Forcepoint Email Security, Forcepoint URL Filtering, Forcepoint Web Security, TRITON AP-DATA, TRITON AP-EMAIL, TRITON AP-WEB, Web Security Gateway, Web Security and Web Filter
- Version: 8.5, 8.4, 8.3, 8.2, 8.1, 8.0, 7.8, 7.7, 7.6, 7.5, 7.3, 7.2, 7.1, 7.0
- Last Published Date: June 30, 2020
I receive this error message in the SQL logs:
"The job failed. Unable to determine if the owner (server\administrator) of job testjob has server access (reason: Could not obtain information about Windows NT group/user 'server\administrator'. [SQLSTATE 42000] (Error 8198))."
Recreating the SQL jobs does not resolve the issue. How do I correct this error?
This problem occurs when the SQL jobs owners' account cannot be authenticated. To resolve, change the owner of all three Websense jobs to the SQL account used by the Websense ODBC connection (for example, the SQL "sa" account). To change the owner, see the following Microsoft articles:
Note We recommend that you also restart any other instances of SQL Server Agent that are installed on your server.