Shulou(Shulou.com)06/01 Report--

The job runs as "domain\ user" and encounters the following error:

JOB RUN: 'Product_JobTest' was run on 2016-10-27 at 4:30:00DURATION: 0 hours, 0 minutes, 0 secondsSTATUS: FailedMESSAGES: 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/

An attempt was made to change the job owner to sa, and two problems were encountered:

1. For report subscription jobs generated by the report service, 2008R2 failed to modify the subscription scheduling time, and 2014 did not encounter this problem.

two。 The cross-server access jobs deployed by the business will be verified by the startup account of the SQL Server Agent service, and the access permissions of LINKEDSERVER need to be configured.

Solution:

On the domain control server, add the startup account of the SQL Server service to "BUILTIN\ Windows Authorization Access Group", and then let the job run with "domain\ user" as the owner, and there will be no error.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.