running job to invoke stored procedure which runs linked server

[giovi2002]

I've setup a linked server on my localserver. Both servers sql server 2000.

Within the security tab of my linked server i've mapped my username to the username valid on the linked server.

Within my stored procedure i refer to the linked server.
When executing the stored procedure within query analyzer everything works fine!

Next thing i wanted to do is schedule execution of the procedure. I've
simply put a step within the job to execute the stored procedure.

When running the job I receive the following error:
Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' reported an error. Authentication failed. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.]. [SQLSTATE 01000] (Error 7300). The step failed.

 

[philhege]

Who owns the job? What account is the SQL Server Agent running under?

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[giovi2002]

I found it. You need to check your SQL Server agent service properties and use an account which is mapped into the linked server security tab