Bannikov

PI OLEDB Enterprise as linked server and SQL authorization

Discussion created by Bannikov on Aug 16, 2012
Latest reply on Aug 22, 2012 by mhamel

Hello all!

 

I've such problem. I've Microsoft SQL Server and PI OLEDB Enterprise as linked server to it. We've develop a stored procedure that extract some data from AF using OLEDB Enterprise, combines it with data in SQL Server and return as result. All's working fine when I use Windows authorization to connect to SQL and execute this procedure.

 

But our application (based on IBM ILOG ODM) cannot use Windows authorization to connect to SQL Server, only SQL authorization can be used. I've executed my procedure under SQL authorization, and error message appear (I'll post the detail a bit later)

 

My question is: in case SQL authorization is used, which settings should be made on OLEDB Enterprise as Linked Server in SQL? Thank you in advance!

Outcomes