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 2024 R2)

TABLE OF CONTENTS

Configure distributor database security

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

When you create a PI AF collective, a distributor database is created to allow for SQL Server replication. That database requires some configuration.

The distributor database is named <PIFD>_distribution, where <PIFD> is the name of the PI AF SQL database. By default the name of the PI AF SQL database is PIFD.

The AFServers group must have the db_AFServer role for the <PIFD>_distribution database. This role is automatically assigned to the local AFServers group during the PI AF collective creation.

However, if you are installing a PI AF collective on a SQL Server cluster, the local AFServers group does not exist; it was replaced with a domain group as part of the process of installing PI AF on a SQL Server cluster.

If the AFServers domain group does not have the db_AFServer role for the <PIFD>_distribution database, the collective creation will fail with an error message:

Waiting on a (Good) SyncStatus .. Current SyncStatus(Snapshot Not Ready)

This error can be corrected during the PI AF collective creation process; it is not necessary to exit the Create New Collective window. The PI AF collective creation process will continue normally after the following steps are completed.

  1. Open Microsoft SQL Server Management Studio, and connect to the SQL Server instance for the primary server in the PI AF collective.

  2. Under the SQL Server cluster instance, expand Security > Logins.

  3. Right-click the login created for the AFServers domain group and select Properties.

  4. Select the User Mapping page.

  5. Under Users mapped to this login, select the Map check box for the <PIFD>_distribution database row.

  6. Ensure the User column for the <PIFD>_distribution row is set to the domain user group (YourDomain\YourAFDomainGroup).

  7. With the <PIFD>_distribution row selected, select the db_AFServer role check box under Database role membership for: <PIFD>_distribution. The public role should be selected by default; if it is not, select its check box.

  8. Click OK to save the SQL Server login.

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