I am getting this error when I run a linked server query from my local pc.
OLE DB provider "DB2OLEDB" for linked server "DB2_SD_SDINFO_RTXD01F4" returned message "".
Msg 7303, Level 16, State 1, Procedure sp_catalogs, Line 7
Cannot initialize the data source object of OLE DB provider "DB2OLEDB" for linked server "DB2_SD_SDINFO_RTXD01F4".
The strange part is this.. I can run this query remotely using a sql account but it will not work using a windows account. I am testing this with my windows id when I get this error and this account has sa permission on the SQL 2005 Instance.
I have the Microosoft OLE DB Provider for DB2 1.0 with SP 1.
Have any of you seen this issue before?
This server is running windows 2003 and I am using SQL 2005 EE x64 edition.