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.