SQL Server 2008 R2
I've created a SQL Server job which will run several consecutive stored procedures. These procedures pull data from a linked server "XXX-P2DB" and dump it into several tables in a database on my primary server. When I run these procedures separately, they each succeed, but when I run these procedures in the job, I'm getting the following error message:
Executed as user: XXX\administrator.
The OLE DB provider "SQLNCLI10" for linked server "XXX-P2DB" reported an error. Authentication failed. [SQLSTATE 42000] (Error 7399)
Cannot initialize the data source object of OLE DB provider "SQLNCLI10" for linked server "XXX-P2DB". [SQLSTATE 42000] (Error 7303)
OLE DB provider "SQLNCLI10" for linked server "XXX-P2DB" returned message "Invalid authorization specification". [SQLSTATE 01000] (Error 7412). The step failed.
The job steps look like:
and the job step properties look like: