Page History

Install 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 is 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. Accept the Terms and Conditions and click Next.
4. Select Install IDERA Dashboard locally and click Next.
5. Select the folder where you want to install IDERA Dashboard and click Next.
6. Enter the service account username and password and click Next.
7. Select the ports that you wnat to host the IDERA Dashboard services on and click Next.
8. Select the SQL Server Instance which has been configured for High Availability and click Next.
   
9. On the next wizard click Install.
10. Click Finish on the final wizard.
    

Installation steps.

 Configuring SQL Server  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 and connect to the cluster environment’s SQL Server Instance on the cluster environment.

2. Under Databases, right click on the IDERA Dashboard repository IderaDashboardRepository and click properties.
3. Go to the options tab from the left hand side and set the recovery model to full
   , click Ok to save the changes by clicking ok .
   
4. After the backup is complete go to Always on High Availability, and under Availibity Availability Group select Add Database
5. Click Next on the wizard.
   
6. Select the IDERA Dashboard Repository and Click Next.
7. Select Full data synchronization preference and click Next.
8. Connect to all the secondary nodes and click Next.
9. Let the validation run and click Next.
10. Click Finish
    
11. When the wizard completes click close

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.

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

1. Go to Roles Tab of  Windows Failover Cluster Manager

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

3. Continue browsing the Idera Dashboard application. The application will be functioning normally.