Page History
...
- 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
- Right-click on Role and select Create Empty Role
- Right-click on New Role and select Properties
- Specify a new name for the role and click OK
- Right-click on the Role, select Add Resource, and click Client Access Point
- When the New Resource Wizard promptsopens, type an uniquenetwork unique network name and an IP address, and click Next
- Click Next on the Confirmation screen
- Click Finish on the Summary screen
- Right-click on the Role and select Add Storage
- Select a disk, and click OK
- In File Explorer, create a folder to be used by SQLDM services on the disk that was added
- Open Registry Editor and navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Idera\SQLdm
- Right-click on the SQLdm key, select New, click Key, and enter DataPath for the name
- Right-click on the DataPath key, select new, click String Value, and enter DataPath for the name
- Double-click on the string value and enter the path to the foderthat foder that was created for SQLDM services, click OK
- Go back to Failover Cluster Manager
- Right-click on the role, select Add Resource, and click Generic Service
- On the Select Service screen, select the SQLdm Collection Service, and click Next
- Click Next on the Confirmation screen
- Click Finish on the Summary screen
- Repeat steps 17-20 for the remaining SQLDM services: SQLdm Management Service, SQLdm Predictive Analytics Service, and SQLdm Rest Service
- Right-click on one of the added SQLDM service services and select Properties
- Go to Dependencies tab and add the following resources:
- Name
- IP Address
- Disk
- Click Apply and go to the General tab
- Check the box of Use network name for computernamecomputer name, and click Apply
Go to the Registry Replication tab, click Add, enter SOFTWARE\Idera\SQLdm\DataPath, 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
PowerShell cmdlet to add the necessary setting.Newtablink alias Add-ClusterCheckpoint url https://docs.microsoft.com/en-us/powershell/module/failoverclusters/add-clustercheckpoint?view=win10-ps EXAMPLE: Add-ClusterCheckpoint -ResourceName "SQLdmCollectionService`$Default" -RegistryCheckpoint "SOFTWARE\Idera\SQLdm\DataPath" -Cluster "SQLdmServices"
- Click Apply, and then click OK
- Repeat steps 17-27 for the remaining SQLDM services: SQLdm Management Service, SQLdm Predictive Analytics Service, and SQLdm Rest Service
...