Configure HA deployment whitelist to support FglAM HA for SQL PI (using a SQL Server PI repository) (4229575)

WORKAROUND

1. Navigate to Administration | Agents | Agent Properties

2. Select FglAM | FglAMAdapter

3. Click the Edit button next to the Deployment WhiteList

4. Click Add Row and then add each of the values as shown below

DB_SQL_Server regular expression (to add SSAS, SSAS SPI Repository, and MSSQL SPI Repository agents)

DB_SQL_Server/(5\.7\.1\.([2-9]|[1-9][0-9]+)|5\.7\.([2-9]|[1-9][0-9]+)\.[0-9]+|5\.([8-9]|[1-9][0-9]+)\.[0-9]+\.[0-9]+|6\.([0-9])\.[0-9]+\.[0-9]+)/(DB_SQL_Server|DB_SQL_Server_Installer|SSAS_Agent|DB_SQL_Server_SPI_Repository|SSAS_SPI_Repository)

DB_Oracle regular expression (to add Oracle SPI repository agent)

DB_Oracle/(5\.7\.1\.([2-9]|[1-9][0-9]+)|5\.7\.([2-9]|[1-9][0-9]+)\.[0-9]+|5\.([8-9]|[1-9][0-9]+)\.[0-9]+\.[0-9]+|6\.([0-9])\.[0-9]+\.[0-9]+)/(DB_Oracle|DB_Oracle_RAC|DB_Oracle_RAC_Instance|DB_Oracle_ASM|DB_Oracle_CRS|DB_Oracle_Exadata|DB_Oracle_Installer|DB_Oracle_SPI_Repository)

SPI Repository regular expression (add a new row for the SPI Repository agent)

SPIRepository/.*/SPIRepository

5. Click the Save button

6. Select the previous SQL Server and Oracle entries (higher in the list) and click the Delete Selected Row(s) button

The resulting panel should resemble this

7. Click the Close button