Loading...

Creating an MSSQL Availability Group Client

After the SQL Agent is installed on all the physical nodes of an AlwaysOn cluster, create a new Availability Group (AG) client.

Procedure

  1. From the CommCell Browser, right-click the Client Computers, and then click New Client > Application > MSSQL AG.
  2. In the Create MSSQL AG Client dialog box, set up the AG client:
    1. In the New Client box, type a name for the AG client.

      The name of the AG client has no dependency on the actual availability groups.

    2. In the SQL Client box, select a client from the list displaying SQL 2012 or later clients.

      Ensure that the selected SQL Server is the primary replica of the availability group that you are planning to protect.

    3. In the SQL Instances box, select an instance from the list of available SQL instances.

      If the SQL client has only one instance, then that instance is automatically selected.

    4. In the Availability Group box, select an availability group from the list.

      If the SQL client has only one availability group, then that availability group is automatically selected.

    5. Click OK.

The new AG client is created in the CommCell Console, which also displays the name of the availability group selected.

What to Do Next

After adding an Availability Group to an existing AG client, you can configure the default subclient or create a new subclient the same way that you create a regular SQL subclient: