PI AF SQL Server database installation in a failover cluster

Before you begin, make sure you complete the steps listed in Pre-installation tasks for PI AF in a failover cluster.

Complete these procedures in the SQL Server Cluster that will hold the PI AF SQL Server database. It is important that you complete these procedures to install and configure the PI AF SQL Server database before you install and configure the PI AF Application Service on a different machine.

The PI AF SQL Server database must be created by manually executing the SQL scripts. We recommend that you download the SQL Scripts from the Customer Portal and manually execute the scripts without running the PI Server install kit. This method is preferable to executing the install kit on the PI AF SQL Server database machines directly to create the PI AF SQL Server database, as this impacts the system resources of those machines.

Note: To run the necessary scripts from the command line, you must first install the ODBC version of the sqlcmd utility. For information about installing the ODBC version, see the Microsoft article sqlcmd Utility.