Enabling the Always On Availability Groups feature

Last Updated : Aug 04, 2023 |

About this task

You must enable the Always On Availability Groups feature on every SQL Server instance in the cluster.

Procedure

  1. Log in to the EDM server.
  2. Click Start > Microsoft SQL Server > SQL Server Configuration Manager.
  3. In the navigation pane, click SQL Server Services.
  4. In the content pane, right-click the SQL Server instance, and then click Properties.

    The SQL Server Properties dialog box opens.

  5. Select the Always On Availability Groups tab (AlwaysOn High Availability in SQL Server 2016):
    1. In the Windows Server Failover Cluster field (Windows failover cluster name in SQL Server 2016), ensure the correct Windows Server Failover Cluster is selected.
    2. Select the Enable Always On Availability Groups check box (Enable AlwaysOn Availability Groups in SQL Server 2016).
  6. On the Log On tab, select This account, and enter the account name and password of the domain user that was used to create the Windows Server Failover Cluster.

    Ensure that you include the domain in the account name. For example, myDomain\myUsername.

  7. Click OK.
  8. In the content pane, right-click the SQL Server instance and click Restart.
  9. Repeat the process for each SQL Server instance in the cluster.