This procedure guides you through the installation of SQLdm in a high availability group. SQLdm does not support direct installations under this scenario; however, you can deploy the SQLdm Repository in one of the nodes that belongs to a specific availability group and configure an availability group listener that serves as a global link between nodes.

Make sure to restart the SQLdm services, apply the newly-generated license using the Manage Licenses button before attempting to apply the license directly using the Management Console or you may encounter issues.

  1. Deploy the SQLdm Repository targeting a node that is part of an availability group. For example, Node 1\Instance A.
  2. Move the SQLdm Repository to an availability group in the primary replica with Listener Y and port 300 (as example). To review how to create an availability group, see Microsoft document Creating and Configuring a New Availability Group.
  3. A new license key for Listener Y, Port 300 is required. See Capturing an availability group's listener name and port designation to send your request to Idera Sales.
  4. Using the SQLdm Management Service Configuration wizard modify the target repository to Listener Y, port 300.

  5. Save changes, and then restart the SQLdm services. This process takes approximately 5 minutes.

  6. Upon opening the SQLdm Console, the system recognizes that you are trying to access the selected node without the proper license and throws an error message.

  7. Click the Manage Licenses button of the error message and type the new license for Listener Y, Port 300. Open the SQLdm Console, go to Help > Manage Licenses in the Toolbar menu, and the License Keys window displays. Type the new license key in the available space, and then click Enter.

 

SQL  Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
  • No labels