KB Article | Forcepoint Support

Problem Description

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?

Resolution

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: 

To resolve this problem, change the job owner to a standard SQL Server user or to a standard SQL Server system administrator. To do this, follow these steps:
 

  1. Start SQL Server Enterprise Manager.
  2. Expand Microsoft SQL Servers, and then expand SQL Server Group.
  3. Expand your server name.
  4. Expand Management, and then expand SQL Server Agent.
  5. Click Jobs. In the right pane, right-click the job that failed, and then click Properties.
  6. In the Properties dialog box, click Owner on the General tab to display the list of owners.
  7. In the Owner list, click the SQL Server user who you want to use. Alternatively, click sa, and then click OK.
  8. When you are prompted to stop and to restart SQLAgent, click OK.
  9. Restart any instances of SQL Server.

Note We recommend that you also restart any other instances of SQL Server Agent that are installed on your server. 

For additional information, see Changing Service Account causes xp_logininfo to error.




keywords:

8198; sql; dba; permission; account; sqlagent; odbc;

 

 

Article Feedback



Thank you for the feedback and comments.