I have setup a job in SQL Server 7.0 that executes a stored procedure. The
sp talks to a remote SQL server. When I execute the stored procedure
manually in Query Analyzer, it works beautifully. But when the sp is called
from within a job, it gives me this error message when I select * from
"Remote access not allowed for Windows NT user activated by SETUSER
[SQLSTATE 42000] (Error 7410)"
Aside from the NT user account used by the SQL Agent service, there is no NT
user account associated with this process. I have the Linked server security
mapped to a SQL account and sa owns the job.
Appreciate any and all helpful feedback.