Export (0) Print
Expand All

Enabling the HADR Service on a Server Instance (SQL Server Configuration Manager)

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

To enable the HADR service, you must use the SQL Server Configuration Manager.

Prerequisites

Ensure that the instance of SQL Server meets the following prerequisites:

Note Note

For information about viewing the current status of the HADR service, see Determining Whether a SQL Server Instance is HADR Enabled.

Security

While the HADR service is enabled on an instance of SQL Server, the server instance has full control on the WSFC failover cluster. 

Permissions

Requires that you be a member of the Administrator group on the local computer with full control on the WSFC failover cluster.

Limitations and Restrictions

When you enable the HADR service for more than one SQL Server instance, you must complete the enabling process one instance at a time. The enabling process is complete when the SQL Server service has been restarted on the instance where you are currently enabling the HADR service.

[Top]

To enable the HADR service

  1. Connect to the Windows Server Failover Clustering (WSFC) node that hosts the SQL Server instance on which you want to enable the HADR service.

  2. On the Start menu, point to All Programs, point to Microsoft SQL Server Code-Named "Denali", point to Configuration Tools, and then 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 the HADR service, and click Properties.

  4. Select the SQL HADR tab.

  5. Verify that Windows failover cluster name field is displaying the name of the local failover cluster node. If this field is blank, this server instance currently does not support the HADR service. Either the local computer is not a cluster node or the WSFC failover cluster has been shut down.

  6. Select the Enable SQL HADR Service check box, and click OK.

    Note Note

    If the Enable HADR Service check box is already selected, the service has already been enabled.

    SQL Server Configuration Manager saves your change. Then you must manually restart the SQL Server service. . When the SQL Server service restarts, the HADR service will be enabled.

    Note Note

    On restart, the IsHadrEnabled server property will be set to 1, indicating that HADR service is enabled.

[Top]

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft