SQL Server 2008 Job failure cannot determine whether the owner has server access rights

Call Job---error message content

The job failed.  'win-3th1knit12d\administrator'0x5344200015404).

Cause:

Previous user name or computer name with the operating system modified
1.SQL Server Agent

2. Job 3. Select the corresponding job, double-click Open-General-owner-Select the login name, regardlessis the same as the current name, all re-selected once, OK, yes. 4.if the current user name does not exist, then the Security--"login name to make changes

(Note that the login name is the same as the existing name, and the difference needs to be changed manually )

5. Eventually change the owner to NT Authority\System, and the job executes successfully. #此步骤没有试过, the normal processing 1234 can solve the problem!

Description: Change the owner of the job schedule, not the database owner

Another method is to call a stored procedure to back up, test pass, process reference: http://blog.csdn.net/apollokk/article/details/50291731

SQL Server 2008 Job failure cannot determine whether the owner has server access rights