Configure PI SQL DAS

Note: The configuration of PI SQL DAS is optional.

Use the PiSqlDasAutoConfig.exe configuration tool for all basic configurations of PI SQL DAS. The tool is located in the PIHOME\SQLDAS\Tools directory, where PIHOME is your PIPC installation directory.

If your IT policies require that you use enterprise-type certificates, you can use the tool to configure an enterprise certificate for PI SQL DAS and bind it to the port used by PI SQL DAS.

1. In a command prompt, run the tool with parameter -e. For example: From the C:\Program Files\PIPC\SQLDAS\Tools directory, type PiSqlDasAutoConfig.exe -e.

2. Optional: Select a certificate from the Certificates dialog. The certificate must be intended at least for Client Authentication and Server Authentication.

   Note: Enterprise certificates are typically already installed on your computer if it is part of a domain. You should see your organization's name in the Issued by row. The certificate named PISQLDAS is the self-signed certificate used by default.

3. Click OK.

4. This output indicates that the selected certificate has been bound to the SSL port:

   C:\Program Files\PIPC\SQLDAS\Tools>PiSqlDasAutoConfig.exe –e
   Found existing binding ....deleted
   Create new SSL binding ....OK
   Updating config file.......OK

   In this example, the tool has configured the selected certificate to be used by PI SQL DAS and bound this certificate to IP address/port 0.0.0.0:5461.

5. Restart the PI SQL DAS service to use the new configuration.