Page History

To Install the IDERA Dashboard on any machine with the repository hosted on a High Availability SQL Server Instance

After your cluster environment and your availability group are set up, install the IDERA Dashboard on any server of your virtual machine following the normal installation steps

1. Run the Idera Dashboard installation file on your respective server.

2. Click Next to the Welcome Wizard.
3. Click “Next” at the Wizard’s welcome screen.
4. Accept the Terms and Conditions and click “Next”.
5. Select Install “Idera Dashboard Locally” and Click “Next”.
6. Select the folder you want to install Dashboard to and click “Next”.
7. Enter the service account username and password and click “Next”.
8. Select the ports that you want to host the Idera Dashboard services on and click “Next”.
9. Select the SQL Server Instance which has been configured for High Availability

1. Click Install on the final screen

Click Finish

 Configuring SQL SERVER Database for High Availabil

1. Go to SQL Server Management Studio from a local machine or a remote machine on the same network and connect to the cluster environment’s SQL Server Instance.

1. Under “Databases”, Right-Click on the Idera Dashboard repository and click “properties”

1. Go to the “Options” tab from the Left hand side and set the Recovery model to “Full”

2. Save the changes by clicking “OK”

3. Now right-click on the repository and under Tasks, select “Back Up..”

4. Select “FULL” backup type and click “Ok”

5. After the backup is complete, Go to ‘Always ON High Availability’, and under ‘Availability Group’, Select “Add Database..” 

6. This opens wizard. Click ‘Next’ on the Wizard

1. Select the Idera Dashboard Repository and click “Next”

2. Select “Full” data synchronization preference and click “Next”

3. Connect to all the secondary nodes and click “Next”

4. Let the validation run and click ‘Next’

5. Click ‘Finish’

6. When the wizard completes click “Close”

5: Checking Failover of Database

When the Installation is successful, we should be able to access the Idera Dashboard from the desktop shortcut

The Idera Dashboard should appear on the default browser

We can install any IDERA product of choice over this Idera Dashboard. In this instance, the SQL Inventory Manager has been installed.

Failover of the database can be performed in 2 ways

1 - Manual Failover from SQL Server Management Studio.

Steps:

1. Failover the Availability Group from SQLServer Management Studio From the primary node.

2. Click “Next”

3. Select an appropriate failover node and click “Next”

4. Connect to the respective node and click “Next”

5. Click “Finish”

6. Click “Close”

7. Now continue to browse Idera Dashboard. The application will be unaffected.

2 - Failover from Windows Failover Cluster Manager

Steps

, make sure you have set up a Windows Failover Cluster and a SQL Server Instance for High Availability. Find more information

Installation Steps for IDERA Dashboard on a High Availability Group

1. Install the IDERA Dashboard on your machine following the Installation Steps.
2. Go to SQL Server Management Studio and connect to the SQL Server Instance where you installed the IDERA Dashboard.
3. Under Databases, right-click on the IderaDashboardRepository and select properties. On the wizard, select Options and run a Full Recovery model.
   Image Added
   
4. Right click on IderaDashboardRepository, select Tasks, and run a Full Back up.
   

   Image Added

5. To configure your Availability Group, right-click on Availability Groups and select New Availability Group Wizard...
   Image Added
   
6. On the Introduction wizard click Next.
   Image Added
   
7. Provide a name to the availability group. Click Next. 
   Image Added
   
8. On the list of available user databases, check the box of the IderaDashboardRepository database.
   Image Added
   
9. 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.
10. 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.
11. On the Endpoints tab, make sure that the port number value is 5022.
12. 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
    
13. Select the Full option, and provide a shared folder location accessible by all replicas.Click Next.
    Image Added
14. Verify that all results return Success. Click Next.
    Image Added
15. The Summary page displays all the actions to be performed. Click Finish when ready.
    Image Added
16. Verify that all results return Success. Click Close.
    Image Added
17. On SQL Server Management Studio, you can verify that the IderaDashboardRepository database is Synchronized on the configured Replicas.
    Image Added
    

...

Go to Roles Tab of  Windows Failover Cluster Manager

...

Right-Click on the Availability Group where the Dashboard repository has been configured and select Move to Best Possible node.

...