Page History

...

1. Open SQL Server Management Studio (SSMS) on the primary node and connect the listener name.
2. Set the Recovery Model of the IderaDashboardRepository and SQLdmRepository databases to Full.
   
3. Perform a full backup of the IderaDashboardRepository and SQLdmRepository databases.
4. Right-click the appropriate availability group and select Add Database...
   
5. On the Introduction screen of the Add Database to Availability Group wizard, click Next.
   
   
   
6. On the Select Database tab, select the IderaDashboardRepository and SQLdmRepository databases, and click Next.
   
   
   
7. On the Connect to Replicas tab, connect to the other replica(s) in the availability groups by clicking Connect... next to the Server Instances, and click Next.
8. On the Select Data Synchronization tab, select one of the following options for your environment, and click Next.
   1. Automatic Seeding
   2. Full database and log backup
   3. Join only
   4. Skip initial data synchronization
9. On the Validation screen, ensure that all tests are successful and click Next.
   
   
   
10. On the Summary screen, verify the actions you selected in the previous steps, and click Finish.
    
11. The Results screen displays the summary of the performed actions and their results, click Close to exit the wizard.
12. In SSMS connect to the secondary replica(s) and ensure that the databases were added successfully.
13. On the server where SQL Diagnostic Manager is installed, restart the services listed below:
    1. IDERA Dashboard Core Service
    2. IDERA Dashboard Web Service
    3. SQLdm Collection Service
    4. SQLdm Management Service
    5. SQLdm Predictive Analytics Service
    6. SQLdm Rest Service

Validate SQL Diagnostic Manager

...

Configuration

1. To validate the SQL Diagnostic Manager configuration, launch the Desktop Client.
2. Go to > Manage License. In the New Key section, you should see the name of the listener and the port instead of the primary node name.
   
    
   If you see the listener and port as shown in the image above, you have successfully configured the repository databases in an availability group.

...