Page History

...

1. Launch Failover Cluster Manager on a node of the cluster. For more information on how to launch the Failover Cluster Manager, check Installing the Failover Cluster Feature and Tools in Windows Server 2012
2. Right-click on Role and select Create Empty Role
3. Right-click on New Role and select Properties
4. Specify a new name for the role and click OK
5. Right-click on the Role, select Add Resource, and click Client Access Point
6. When the New Resource Wizard opens, type an unique network name and an IP address, and click Next
7. Click Next on the Confirmation screen
8. Click Finish on the Summary screen
9. Right-click on the Role and select Add Storage
10. Select a disk, and click OK
11. In File Explorer, create a folder to be used by SQLDM services on the disk that was added
12. Open Registry Editor and navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Idera\SQLdm
13. Right-click the SQLdm key, select New, click Key, and enter DataPath Default for the name
14. Right-click the DataPath Default key, select new, click String Value, and enter DataPath for the name
15. Double-click the string value and enter the path to the foder folder that was created for SQLDM services, click OK
16. Go back to Failover Cluster Manager
17. Right-click on the role, select Add Resource, and click Generic Service
18. On the Select Service screen, select the SQLdm Collection Service, and click Next
19. Click Next on the Confirmation screen
20. Click Finish on the Summary screen
21. Repeat steps 17-20 for the remaining SQLDM services: SQLdm Management Service, SQLdm Predictive Analytics Service, and SQLdm Rest Service
22. Right-click on one of the added SQLDM services and select Properties
23. Go to Dependencies tab and add the following resources:
    1. Name
    2. IP Address
    3. Disk
24. Click Apply and go to the General tab
25. Check the box of Use network name for computer name, and click Apply

26. Go to the Registry Replication tab, click Add, enter SOFTWARE\Idera\SQLdm\DataPathDefault, and click OK

    Warning

    There is a bug in Window 2012 where the Registry Replication tab is not available. If the tab is unavailable, use the Newtablink alias Add-ClusterCheckpoint url https://docs.microsoft.com/en-us/powershell/module/failoverclusters/add-clustercheckpoint?view=win10-ps PowerShell cmdlet to add the necessary setting. EXAMPLE: Add-ClusterCheckpoint -ResourceName "SQLdmCollectionService`$Default" -RegistryCheckpoint "SOFTWARE\Idera\SQLdm\DataPathDefault" -Cluster "SQLdmServices"

27. Click Apply, and then click OK
28. Repeat steps 17-27 for the remaining SQLDM services: SQLdm Management Service, SQLdm Predictive Analytics Service, and SQLdm Rest Service
29. Right-click on each SQLDM service and select Bring Online

...

The following set of instructions helps you to add the SQL Diagnostic Manager services to an existing role:

1. In File Explorer, create a folder to be used by SQLDM services on a disk that has been added as a cluster resource.
2. Open Registry Editor and navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Idera\SQLdm
3. Right-click the SQLdm key, select New, click Key, and enter Default for the name
4. Right-click the Defaultkey, select new, click String Value, and enter DataPath for the name
5. Double-click the string value and enter the path to the folder that was created for SQLDM services, click OK
6. Launch Failover Cluster Manager on a node of the cluster. For more information on how to launch the Failover Cluster Manager, check

   Newtablink
   alias Installing the Failover Cluster Feature and Tools in Windows Server 2012 url https://blogs.msdn.microsoft.com/clustering/2012/04/06/installing-the-failover-cluster-feature-and-tools-in-windows-server-2012/

7. Right-click on an existing role, select Add Resource, and click Generic Service
8. On the Select Service screen, select SQLdmCollection Service, and click Next
9. Click Next on theConfimation screen
10. Click Finish on the Summary screen
11. Repeat steps 2-5 for the reimaining SQLDM services: SQLdm Management Service, SQLdm Predictive Analytics Service, and SQLdm Rest Service

12. Right-click on one of the added SQLDM service, and select Properties

13. Go to Dependencies tab and add the following resources:
    
    1. Name
    2. IP Address
    3. Disk
14. Click Apply and go to the General tab
15. Check the box of Use network name for computer name, and click Apply.

16. Go to the Registry Replication tab, click Add, enter SOFTWARE\Idera\SQLdm\DataPathDefault, and click OK

    Warning

    There is a bug in Window 2012 where the Registry Replication tab is not available. If the tab is unavailable, use the Newtablink alias Add-ClusterCheckpoint url https://docs.microsoft.com/en-us/powershell/module/failoverclusters/add-clustercheckpoint?view=win10-ps PowerShell cmdlet to add the necessary setting. EXAMPLE: Add-ClusterCheckpoint -ResourceName "SQLdmCollectionService`$Default" -RegistryCheckpoint "SOFTWARE\Idera\SQLdm\DataPathDefault" -Cluster "SQLdmServices"

17. Click Apply, and then click OK
18. Repeat steps 7-13 for the remaining SQLDM services: SQLdm Management Service, SQLdm Predictive Analytics Service, and SQLdm Rest Service
19. Right-click on each SQLDM service and select Bring Online

...