SQL Diagnostic Manager must be installed on each node within the cluster. Perform the following steps on each node:
- On a node of the cluster, download the SQL Diagnostic Manager installation kit ZIP file
- Extract and run the executable file. Once, the extraction of the files completes, the IDERA SQL Diagnostic Manager Quick Start window displays
- Click the Install SQL Diagnostic Manager link
- On the Welcome to the SQL Diagnostic Manager Setup, click Next
- Review the license agreement. To accept this agreement, check the box I accept the terms and conditions of this License Agreement, and click Next
- On the Customize your SQLdm setup screen, select both SQLDM Console and SQLDM Services and Repository options, and click Next
- On the Registration with IDERA Dashboard screen, select the Proceed without registration option, and click Next
- On the Service Account, enter your credentials that are used by the SQLDM services, and click Next
- Select the destination directory on the Choose a destination folder screen. Click Next
- Click Install, to start the installation of SQL Diagnostic Manager on the node
- When the installation is completed, uncheck the Launch Idera SQL Diagnostic Manager selection, and click Finish
- Open Windows Services
- Locate and stop the following services:
- SQLdm Collection Service
- SQLdm Management Service
- SQLdm Predictive Analytics Service
- SQLdm Rest Service
- Update the properties for all the mentioned services above, to Manual startup type
- Repeat the steps above for the remaining nodes of the cluster
Once you completed the SQL Diagnostic Manager installation for all the cluster nodes, continue with your the configuration of the Cluster Resource group according to your Windows Server version:
- Windows Server 2003 clustered environment: Configure the Cluster Resource Group
- Windows Server 2008 clustered environment: Configure the Cluster Resource Group
- Windows Server 2012+ clustered environment: Register the SQL Diagnostic Manager Services as a Clustered Resource.