Run the PI SQL DAS (RTQP Engine) setup kit

The configurable parameters can only be changed as part of the installation procedure. If you need to change a parameter after installation, you will have to uninstall PI SQL DAS (RTQP Engine) and reinstall it.

Procedure

1. Double-click PI SQL Data Access Server (RTQP Engine)_version_.exe.

   The self-extracting executable window opens.

2. Select whether you would like to participate in the PI System Customer Experience Improvement Program or not.

3. Select the features to be installed.

   If the SQL Server that runs the PIFD database is on a separate machine, install the AF SQL Database Extension Scripts remotely. The user account that runs the installation must have sufficient permissions on the remote machine and SQL Server. Otherwise, the install kit also needs to be run on the SQL Server machine in order to install the scripts.

   

4. Click Next to proceed to SQL Server connection settings:

   • The SQL Server instance name is automatically detected.

     If the AF Server is not fully configured, you may enter the SQL Server instance name manually.

   • Select the Validate connection to SQL Server option only if the Script installation feature was selected or the scripts have been successfully installed on the SQL Server already.

   • Select a SSL certificate for encrypting the communication.

   • Choose whether to create Windows Firewall Exceptions.

   

5. Proceed to perform any of the following or skip this step to use the default settings:

   • Choose the ports that the service will use.

   • Select a SSL certificate for encrypting the communication.

   • Specify a different account for the PI SQL DAS (RTQP Engine) service, for example a Managed Service Account.

   

   

   The default settings are:

   • The service runs using a virtual service account.

   • HTTPS port defaults to 5464, Net.Tcp to 5465.

   • Self-signed certificate.

   • Firewall exceptions for ports 5464 and 5465 are created.

   Consider the following:

   • If you decide to use Managed Service Account instead of the virtual service account, you must install it on the computer. For more information, see the Add-ADComputerServiceAccount and Install-ADServiceAccount Active Directory cmdlets or Installing a Managed Service Account.

   • If you upgrade from an older version, advanced options are not accessible. PI SQL Data Access Server (RTQP Engine) is installed using the default settings. If you want to use custom settings, you need to manually uninstall the older version prior to installing the new version.

6. Click Install.

7. When the installation completes, click Finish.