Page History

To Install the IDERA Dashboard on any machine with the repository hosted on a High Availability SQL Server Instance, make sure you have set up a Windows Failover Cluster and a SQL Server Instance for High Availability. Configure your cluster environment and your , install Find more information

Installation Steps for IDERA Dashboard on a High Availability Group

1. Install the IDERA Dashboard on

...

1. your

...

1. machine following the

...

1. Installation

...

1. Steps.

 Configuring SQL Server Database for High Availability

1. Go to SQL Server Management Studio
from a local machine or a remote machine on the same network
2. and connect to the SQL Server Instance
on the cluster environment
3. where you installed the IDERA Dashboard.
Image Removed

4. Under Databases, right-click on the IderaDashboardRepository and select properties. On the wizard, select Options and run a Full Recovery model.
   Image Added
   
5. Right click on IderaDashboardRepository, select Tasks, and run a Full Back up.
   

   Image Added

6. To configure your Availability Group, right-click on Availability Groups and
click properties
7. select New Availability Group Wizard...
   Image Added
   
8. On the Introduction wizard click Next.
   
Image Removed
9. Image Added
   
10. Go to the options tab from the left hand side and set the recovery model to full, click Ok to save the changes.
    Image Removed
    
11. After the backup is complete go to Always on High Availability, and under Availability Group select Add Database
    Image Removed
    
12. Click Next on the wizard.
    Image Removed
    
13. Select the IDERA Dashboard Repository and Click Next.
    Image Removed
    
14. Select Full data synchronization preference and click Next.
    Image Removed
    
15. Connect to all the secondary nodes and click Next.
    Image Removed
    
16. Let the validation run and click Next.
    Image Removed
    
17. Click Finish 
    Image Removed
    
18. When the wizard completes click close
    Image Removed
19. sdfkvnpoefv
    Image Removed
20. asdfvgas
    Image Removed
21. afvasv
    Image Removed
aFCWF
Image Removed
22. Provide a name to the availability group. Click Next. 
    Image Added
    
23. On the list of available user databases, check the box of the IderaDashboardRepository database.
    Image Added
    
24. The Specify Replicas page, displays as default the server where you are configuring your High Availability Group, click Add Replica..., and browse the servers to be included on the Availability Group.
25. Check the boxes of Automatic Failover (Up to 2), Synchronous Commit (up to 3), and select No on the Readable Secondary option, on all your replicas.
26. On the Endpoints tab, make sure that the port number value is 5022.
27. On the Listener tab, provide a Listener DNS Name with the port number 1433and click Add..., in the Add IP Address dialog box, enter your preferred virtual IP address in the IPv4 Address field. Click OK. Click Next.
    Image Added
    
28. Select the Full option, and provide a shared folder location accessible by all replicas.Click Next.
    Image Added
29. Verify that all results return Success. Click Next.
    Image Added
30. The Summary page displays all the actions to be performed. Click Finish when ready.
    Image Added
31. Verify that all results return Success. Click Close.
    Image Added
32. On SQL Server Management Studio, you can verify that the IderaDashboardRepository database is Synchronized on the configured Replicas.
    Image Added