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?