Scheduling a stored procedure across sql servers

[Grant007]

Hi Guys,

I have a scheduled job which is run from one sql server but sucks information in from another sql server. i have linked the servers and if i execute the stored procedure manually it works fine... the moment i put it into a schedule to try to get it working automatically it fails miserably..

any suggestions would be greatfully received...

here is the job history message i get..


Executed as user: X. OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initialize returned 0x80004005: ]. [SQLSTATE 01000] (Error 7300). The step failed.

 

[mrdenny]

It's probably got to do with the security settings on the second tab of the linked server. Make sure that the account that the SQL Server runs the job under is mapped to an account on the other server.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)