PI OLEDB Enterprise and AF Security

Discussion created by VCampus-METCO on Nov 6, 2013
Latest reply on Nov 6, 2013 by VCampus-METCO

Can someone just confirm how security works between the OLEDB Enterprise Driver and PI-AF / PI Server?


We have an AF server which is on the office domain and the AF Client (OLEDB Ent Driver) is on the same domain.


The PI Server is behind a firewall on a completely separate domain.


So I can use windows authentication to connect to AF itself and a specific PI User account to connect to the PI Server using SQL Commander. How do I do this from the OLEDB connection string?


I see from the 2012 user guide page 13 that I can set "Integrated Security = SSPI" and also "User ID = xxx; Password = xxx". Is the integrated security property for connection to AF and UserID/Password the connection to PI so I need to set all three properties to get everything working as expected?