The following instructions guide you through the installation of SQL Diagnostic Manager in a Windows Server 2003 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 create this separate cluster resource group, gather a dedicated IP, NetBIOS name, and a dedicated disk for the cluster resource group.
• SQLdm Collection, Management, SQLdm Predictive Analytics, and SQLdm Rest services can run as generic services on your newly-created cluster resource group.

Install SQL Diagnostic Manager on a node

SQL Diagnostic Manager must be installed on each node within the cluster and configure the services as its described in the following page, Install SQL Diagnostic Manager on a node.

Configure the Cluster Resource Group

Cluster Resource Group settings must be modified to allow SQL Diagnostic Manager to recognize the cluster nodes.

To configure the Cluster Resource Group:

1. In the Cluster Administrator tool, create the Cluster Resource Group:
   • Select File > New > Group and give the group and description
   • Add the nodes and click Finish 
2. In the Cluster Administrator tool, add a disk to the Cluster Resource Group:
   • Right-click the group you just created, select New > Resource and give it a name and description
   • For the Resource Type, select Physical Disk 
   • Select the SQLdm group
   • Click Next until you get to the last window and click Finish 
3. In the Cluster Administrator tool, add an IP address for the Cluster Resource Group:
   • Right-click the group and select New > Resource and give it a name and description
   • Select the Resource type IP Address 
   • Enter the IP address that you acquired for your new Cluster Resource Group
   • Click Finish .
4. In the Cluster Administrator tool, add the Network Name resource to the Cluster Resource Group:
   • Right-click the group and New > Resource and give it a name
   • Select the Resource type Network Name 
   • Add the dependency for the IP address resource
   • Specify the name and click Finish 
5. Select a Disk that is in a Cluster Resource Group and create a directory on that disk used to hold local data for the services.
6. On the primary node, create the default registry key and add the full data path value under HKEY_LOCAL_MACHINE\SOFTWARE\Idera\SQLdm\Default
7. Create the DataPath value
8. Select a Cluster Resource Group in which you want to define the SQLdm resources
9. Create an IP Address resource for the SQLDM Services. If there is already an existing Network Name in the Cluster Resource Group, then you can skip this step.
   • Create an Network Name resource that maps to the IP Address
   • Create the Network Name resource and add the IP Address as a dependency
10. Create a Generic Service resource for the SQLdm Management Service
    
    • Add the Disk for the shared data as a dependency
    • Add the Network Name as a dependency
    • Specify SQLdmManagementService$Default as the name of the service to start
11. After the service is added, right-click it and select Properties 
    • Select the Parameters tab and check the Use network name for computer name box
    • Select the Registry Replication tab and add SOFTWARE\Idera\SQLdm\Default
    • Click OK
12. Create a Generic Service resource for the SQLDM Collection Service.
    • Add the Disk for the shared data as a dependency
    • Add the Network Name as a dependency
    • Specify SQLdmCollectionService$Default as the name of the service to start
13. After the service is added, right-click it and select Properties
    
    • Select the Parameters tab and check the Use network name for computer name box
    • Select the Registry Replication tab and add SOFTWARE\Idera\SQLdm\Default
    • Click OK
14. Create a Generic Service resource for the SQLdm Predictive Analytics Service.
    • Add the Disk for the shared data as a dependency
    • Add the Network Name as a dependency
    • Specify SQLdmPredictiveAnalyticsService$Default as the name of the service to start
15. After the service is added, right-click it and select Properties
    
    • Select the Parameters tab and check the Use network name for computer name box
    • Select the Registry Replication tab and add SOFTWARE\Idera\SQLdm\Default
    • Click OK
16. In Windows Services, bring the SQLDM Management service resource online
17. In Windows Services, bring the SQLDM Collection service resource online
18. In Windows Services, bring the SQLDM Predictive Analytics service resource online
    
    

 Complete the Cluster Configuration in SQL Diagnostic Manager

1. Use the Management Service Configuration wizard to force the services to re-register
2. 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
3. Verify that your configuration displays correctly in the SQLDM Desktop Client