SQL server error 15404 solution

The job runs with “domain\ User” and the following error is encountered:
 

JOB RUN: 'Product_JobTest' was run on 2016/10/27 at 4:30:00
DURATION: 0 hours, 0 minutes, 0 seconds
STATUS: Failed
MESSAGES: The job failed. Unable to determine if the owner (domain\user) of job Product_JobTest has server access (reason: Could not obtain information about Windows NT group/user 'domain\user', error code 0x5. [SQLSTATE 42000] (Error 15404)).

 
Read the following reference articles:
http://www.cnblogs.com/kerrycode/p/3339558.html
http://www.cnblogs.com/kerrycode/p/5551994.html
http://consulting.risualblogs.com/blog/2013/03/01/could-not-obtain-information-about-windows-nt-groupuser-domainuser-error-code-0x5-sqlstate-42000-error-15404-connisloginsysadmin/
 
We started to try to modify the owner of the job as SA, and encountered two problems:
1. For the report subscription job generated by the report service, the subscription scheduling time of 2008R2 failed to be modified, and this problem was not encountered in 2014.
2. For the cross-server access job deployed by the business, it will be verified with the startup account of SQL Server Agent service, and the access permission of LINKEDSERVER needs to be configured.

Solutions:
On the domain controlled Server, add the startup account of SQL Server service to “BUILTIN\Windows Authorization Access Group”, and then let the job run with “Domain \ User” as the owner, and no error will be reported.


Read More: