Edit

SQL Server Properties (Always On High Availability Tab)

  • Article

Applies to: SQL Server - Windows only

Use the Always On High Availability tab of the SQL Server Properties dialog box in SQL Server Configuration Manager to enable or disable the Always On Availability Groups feature in SQL Server. Enabling Always On Availability Groups is a prerequisite for an instance of SQL Server to use availability groups as a high availability and disaster recovery solution.

Prerequisites

To be enabled for Always On Availability Groups, a server instance must meet the following prerequisites:

  • The server instance must reside on a Windows Server Failover Clustering (WSFC) node.

  • To be in the same availability group, instances must be in the same WSFC cluster. An availability group cannot span WSFC clusters.

  • The server instance must be running an edition of SQL Server that supports Always On availability groups.

  • Enable Always On Availability Groups for only one server instance at a time. After enabling Always On Availability Groups, wait until the SQL Server service has restarted before you enable the next server instance.

Note

For information about feature support and for information about additional prerequisites, restrictions, and recommendations for Always On availability groups, see SQL Server Books Online.

Dialog Options

Windows failover cluster name
Displays the name of the WSFC cluster in which the local computer is a node.

Enable Always On Availability Groups

Use this check box to enable or disable Always On Availability Groups on this instance of SQL Server, as follows:

  • If this check box is empty, Always On Availability Groups is currently disabled. To enable Always On Availability Groups, select this check box, click OK, and manually restart the SQL Server service.

  • If this check box is already selected, Always On Availability Groups is currently enabled. To disable Always On Availability Groups, uncheck the check box and click OK. This causes the server instance to restart.

    Tip

    • After disabling Always On Availability Groups, you should remove any local availability replicas from the server instance. If you remove the last replica of a given availability group, you should also remove the group.
    • If the Always On Availability Groups tab is missing, or the option to enable is grayed out, either your environment isn't supported, or hasn't been properly configured.

UI element list

Note

For more information about follow up after you disable Always On Availability Groups and for information about how to create and configure availability groups, see SQL Server Books Online.