Issue with Sql Job and Linked Server Query
Posted on 2013-05-20
My query to my linked db2 server works fine in a management studio. When I run the same exact query in a sql job. I get the error below. I am running sql server 2008 R2.
Executed as user: NT AUTHORITY\SYSTEM. Cannot initialize the data source object of OLE DB provider "IBMDASQL" for linked server "ISERIES". [SQLSTATE 42000] (Error 7303) OLE DB provider "IBMDASQL" for linked server "ISERIES" returned message "CWBSY1006 - User ID is invalid ". [SQLSTATE 01000] (Error 7412). The step failed