RE: Job failed Error 7410

From: Lan Lewis-Bevan [MS] (lanlb@online.microsoft.com)
Date: 07/10/02 

From: lanlb@online.microsoft.com (Lan Lewis-Bevan [MS])
Date: Wed, 10 Jul 2002 21:19:36 GMT

When you schedule a job to run the SP with a non sysadmin account or a non
sa owner, SQL
Server Agent runs SETUSER to switch to the context of the owner of the Job.
  Since SETUSER cannot impersonate an NT user outside the context of SQL
server without the NT password of that user, after executing SETUSER, SQL
Server disallows remote access.

To work around the problem, you may:

1. Change the job owner to SA.
Or,
2. Try to edit the job step that executes the Stored Procedure from TSQL to
OSQL:

----In the Edit Job step dialog box, general tab, change the type from
?TSQL? to ?Operating System Command?
----Change the command to ?osql -E -Q"exec StoredProc"?

Hope these help.

Thanks.

Lan Lewis-Bevan (MS SQL Support)

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Relevant Pages