Using SQL Server Configuration Manager

To disable AlwaysOn

  1. Connect to the Windows Server Failover Clustering (WSFC) node that hosts the SQL Server instance where you want to disable AlwaysOn Availability Groups.
  2. On the Start menu, point to All Programs, point to Microsoft SQL Server 2014, point to Configuration Tools, and click SQL Server Configuration Manager.
  3. In SQL Server Configuration Manager, click SQL Server Services, right-click SQL Server (<instance name>), where <instance name> is the name of a local server instance for which you want to disable AlwaysOn Availability Groups, and click Properties.
  4. On theAlwaysOn High Availabilitytab, deselect the Enable AlwaysOn Availability Groups check box, and click OK.SQL Server Configuration Manager saves your change and restarts the SQL Server service. When the SQL Server service restarts, AlwaysOn will be disabled, and the IsHadrEnabled server property will be set to 0, to indicate that AlwaysOn Availability Groups is disabled.

To enable AlwaysOn Availability Groups

  1. Connect to the Windows Server Failover Clustering (WSFC) node that hosts the SQL Server instance where you want to enable AlwaysOn Availability Groups.
  2. On the Start menu, point to All Programs, point to Microsoft SQL Server 2014, point to Configuration Tools, and click SQL Server Configuration Manager.
  3. In SQL Server Configuration Manager, click SQL Server Services, right-click SQL Server (<instance name>), where <instance name> is the name of a local server instance for which you want to enable AlwaysOn Availability Groups, and click Properties.
  4. Select the AlwaysOn High Availability tab.
  5. Verify that Windows failover cluster name field contains the name of the local failover cluster. If this field is blank, this server instance currently does not support Always On Availability Groups. Either the local computer is not a cluster node, the WSFC cluster has been shut down, or this edition of SQL Server 2014 that does not support Always On Availability Groups.
  6. Select the Enable AlwaysOn Availability Groups check box, and click OK.SQL Server Configuration Manager saves your change. Then, you must manually restart the SQL Server service. This enables you to choose a restart time that is best for your business requirements. When the SQL Server service restarts, AlwaysOn will be enabled, and the IsHadrEnabled server property will be set to 1.

Check for AlwaysOn Availability Groups feature

SELECT SERVERPROPERTY ('IsHadrEnabled');  

Sources:

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/enable-and-disable-always-on-availability-groups-sql-server?view=sql-server-2014

Last modified: July 1, 2020

Author

Comments

Write a Reply or Comment