Enable trusted servers

Use the following procedure to configure PI SQL Client JDBC to only use trusted servers.

1. Ensure that the PI SQL Data Access Server (RTQP Engine) certificate is in the certificate store of the Java Runtime used by PI SQL Client JDBC by using either the Java keytool.exe or the GetCertificate tool located in the Tools directory in PIHOME\SQL\SQL Client\JDBC.

   See Install a certificate in the Java store for details on using the GetCertificate tool.

2. Open the PISQLJDBC.properties file located in the same folder as the PISQLJDBC.jar file you are using.

   Note: On 64-bit Windows systems, the properties file is located here: PIHOME64\SQL\SQL Client\JDBC.

3. Modify the TrustedServersOnly line as follows:

   <entry key="TrustedServersOnly">True</entry>

4. Save the file.