AnsweredAssumed Answered

Can I connect to PI Server using PI OLEDB ENT 2012 without using Integrated Security=SSPI;

Question asked by Mandeep on Dec 2, 2015
Latest reply on Dec 2, 2015 by Mandeep



I am trying to connect with a PI AF Server using the following connection string (without Integrated Security=SSPI;) from a Microsoft .Net application. But I can't connect and get the below mentioned error.


Provider=PIOLEDBENT; Data Source=PIServerName; UserId=domainname\myusername; Password=mypassword;


System.Data.OleDb.OleDbException: Invalid credentials.User name must be non-empty.


This is a domain account and the credentials are correct because I am able to connect if I use connection string Provider=PIOLEDBENT; Data Source=PIServerName; Integrated Security=SSPI; and run the .Net application under domainname\myusername account that has access to PI Server.


I don't want to run the application under the domain account and want to pass the credentials from the .net application. So please let me know how I can connect to PI AF Server by using Username and password in the connection string?