Use SSMS and DxAdmin to View the Cluster

This guide will walk you through how to view the DxEnterprise cluster and SQL Server using their GUIs.

Prerequisites

• A deployed DxSqlAg custom resource.
• DxAdmin installed on a Windows machine.
• SSMS installed on a Windows machine.
• Port 7979 (DxAdmin) and your SQL Server port or AG listener port exposed via a service. This can be done by following the Creating an AG Listener guide.

Connect Via SSMS and DxAdmin

After the installation is complete, you can connect to your availability group and the DxEnterprise cluster using SQL Server Management Studio (SSMS) and DxAdmin.

View the Availability Group Using SSMS

1. Launch SSMS.

2. Connect to the SQL Server instance using the external IP address of the primary pod (the load balancer IP) and your SQL Server SA password.

3. In the SSMS Object Explorer, expand Always On High Availability > Availability Groups.

4. Right-click on AG1 and select Show Dashboard.

5. You can now browse the AG details pane.

View the DxEnterprise Cluster and AG Using DxAdmin

1. Launch DxAdmin.

2. In the login dialog, enter the external IP address of the primary pod (the load balancer IP) for the Server.

3. In the Passkey field, enter your DxEnterprise cluster passkey.

4. Select Connect Server.

5. After logging in, you will have an overview of the entire DxEnterprise cluster including the availability group. You can show more details by selecting them in the tree view on the left-hand side of the window.

   tip

   You can use DxAdmin to manage the availability group databases. Simply right-click on the availability group in the tree view and select Manage availability databases.

Additional Information

• Service Templates
• DxEnterprise Admin Guide
• Microsoft Learn - SSMS