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.
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.