Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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
    aliasInstalling the Failover Cluster Feature and Tools in Windows Server 2012
    urlhttps://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 27-5 10 for the reimaining remaining 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\Default, 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
    aliasAdd-ClusterCheckpoint
    urlhttps://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\Default" -Cluster "SQLdmServices"

  17. Click Apply, and then click OK
  18. Repeat steps 712-13 17 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

...