Page History

The following instructions guide you through the installation of SQL Diagnostic Manager in a Windows Server 2012 and later based clustered environment.

Things to consider before you install SQL Diagnostic Manager in a clustered environment

• Create a separate cluster resource group to host SQLDM services. A separate group allows the SQLDM services to fail without causing other resources in the group to failover.
• Before you To create this separate a cluster resource group , you need to gather a dedicated IP, NetBIOS name, and a dedicated disk for the cluster resource group.
• SQLdm SQLDM Collection, SQLdm Management, SQLdm Rest Service, and Predictive Analytics services can run as generic services on your newly-created cluster resource group.
• The system may request the network Name and network IP as part of cluster configuration.

Install SQLDM Services on Cluster Nodes

You must install the SQLDM services on each cluster node for the services to work correctly when a failure occurs on the primary cluster node hosting the SQLDM services.

To install SQLDM services on cluster nodes:

1. Log on with an administrator account to the computer on which you want to install SQLDM.
2. Run Setup.exe in the root of the SQLDM installation kit on the first cluster node.
3. Click SQL Diagnostic Manager on the Quick Start window.
4. On the Welcome window of the setup program, click Next.
5. Review and accept the license agreement by clicking I accept the terms in the license agreement, and then click Next.
6. Accept the default installation folder, or click Change to specify a different folder, and then click Next.
7. Select the Typical setup type, and then click Next.
8. Select the SQL Server instance and enter a database name.
9. Enter the service account information, and then click Next.
10. Click Install.
11. In Windows Services, stop the SQLDM Management service and set the Startup type to Manual.
12. In Windows Services, stop the SQLDM Collection service and set the Startup type to Manual.
13. In Windows Services, stop the SQLDM Predictive Analytics service and set the Startup type to Manual.

Repeat the previous steps on each cluster node. Point to the SQLDM Repository installed on the first node.

Configure the Cluster Resource Group

Cluster Resource Group settings must be modified to allow SQL Diagnostic Manager to recognize the cluster nodes. Note that in certain versions of 2012, the Registry Replication tab is missing. A PowerShell command, provided in the instructions below constitutes a workaround for this issue.

To configure the Cluster Resource Group:

...

• In the Select Role tab, select Generic Service.
• In the Select Service tab, select the SQLdm Management Service.
• Enter the network name and IP address for the SQLdm services.
• Select the clustered storage that hosts the path defined in step 1.
• Provide the Registry Replication defined in step 2.
• Verify the settings and click Next to complete the wizard.

...

• On the Dependencies tab, add the name of service and disk, and then click Apply.
• On the General tab, select Use Network Name for computer name, and then click OK.
• To configure the Registry Replication entry, open PowerShell with administrator rights and execute the following command:
  Add-ClusterCheckpoint -ResourceName "SQLdm Management Service (Default)" -RegistryCheckpoint "SOFTWARE\Idera\SQLdm\Default\DataPath"

...

• On the Dependencies tab, add the name of service and disk, and then click Apply.
• On the General tab, select Use Network Name for computer name, and click OK.
• To configure the Registry Replication entry, open PowerShell with administrator rights and execute the following command:
  Add-ClusterCheckpoint -ResourceName "SQLdm Collection Service (Default)" -RegistryCheckpoint "SOFTWARE\Idera\SQLdm\Default\DataPath"

...

• On the Dependencies tab, add the name of service and disk, and then click Apply.
• On the General tab, select Use Network Name for computer name, and click OK.
• To configure the Registry Replication entry, open PowerShell with administrator rights and execute the following command:
  Add-ClusterCheckpoint -ResourceName "SQLdm Predictive Analytics Service(Default)" -RegistryCheckpoint "SOFTWARE\Idera\SQLdm\Default\DataPath"

...

Next, follow the steps described in the links below to complete the installation of SQL Diagnostic Manager on a Windows Server 2012+ clustered environment:

1. Install SQL Diagnostic Manager on a node
2. Register the SQL Diagnostic Manager services as a Clustered Resource
3. Reconfigure the SQL Diagnostic Manager Services and Repository Database
4. Install the IDERA Dashboard and Register the SQL Diagnostic Manager with the IDERA Dashboard

...

Complete the Cluster Configuration in SQL Diagnostic Manager

Start the SQLDM Desktop Client and select SQLDM Repository. If the SQLDM Repository is clustered make sure to use the virtual server name for the SQL Server hosting the SQLDM Repository.