Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ PI Server Installation and Configuration (PI Server 2018)

TABLE OF CONTENTS

Install PI AF in a SQL Server availability group

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedOct 02, 2024
  • 2 minute read

You can use PI Asset Framework (PI AF) for use with a SQL Server availability group when an availability group does not yet exist or within an existing availability group. Use the procedures in these sections to install PI AF and its components on the machines that will be used for the SQL Server availability group.

Before you begin the procedure, make sure to:

  • Verify that the SQL Server machines are configured to support AlwaysOn Availability Groups:

  1. On each SQL Server machine to be used in the availability group, open the SQL Server Configuration Manager.

  2. Right-click the SQL Server service and select Properties. Select the AlwaysOn High Availability page.

  3. Verify that the AlwaysOn Availability Groups check box is selected. If it is not selected, select it and restart the SQL Server service.

    Note: The instructions for installing and upgrading PI AF in a SQL Server availability group are the same for both Always On Availability Groups and Always On Basic Availability Groups.

Install PI AF while creating an availability group

Note: It is important to complete the procedures in the order listed here.

  1. Install PI AF in primary replica machine within a SQL Server AlwaysOn availability group.

  2. Install PI AF on the secondary replica machines.

  3. Install PI AF Application Service on a separate machine.

  4. Create a SQL Server login for the primary replica machine.

  5. Back up the PI AF SQL Server database.

  6. Create SQL Server logins for the secondary replica machines in a SQL Server availability group.

  7. Create a network share for a SQL Server availability group.

  8. Create a SQL Server availability group for use with PI AF.

  9. Configure the PI AF connection string.

    Install PI AF in an existing SQL Server availability group

    Note: It is important to complete the procedures in the order listed here.

    1. Install PI AF in primary replica machine within a SQL Server AlwaysOn availability group.

    2. Install PI AF on the secondary replica machines.

    3. Install PI AF Application Service on a separate machine.

    4. Create a SQL Server login for the primary replica machine.

    5. Back up the PI AF SQL Server database.

    6. Create SQL Server logins for the secondary replica machines in a SQL Server availability group.

    7. Configure the PI AF connection string.

    8. Add a PI AF database.

      In This Topic
      TitleResults for “How to create a CRG?”Also Available in