Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

PI Connector for Wonderware Historian

SQL Windows Authentication

  • Last UpdatedFeb 09, 2023
  • 1 minute read

By default, the connector uses SQL authentication (username and password) as its method of authenticating with the Wonderware SQL server. The preferred method, however, is Windows Authentication.

For Windows Authentication, all that is required is modification of the connection string. Though there are multiple valid SQL connection string parameters that can achieve this (refer to the official Microsoft .NET documentation for details), the simplest method is to modify the value of the default Trusted_Connection parameter from No to Yes.

Note: In the case where the values for DBUsername and DBPassword are not empty, and Windows Authentication has been enabled, the connector ignores the credentials and attempts to authenticate using Windows Authentication instead of SQL authentication.

TitleResults for “How to create a CRG?”Also Available in