Skip to content

Latest commit

 

History

History
103 lines (61 loc) · 9.36 KB

add-or-remove-nodes-in-a-sql-server-failover-cluster-setup.md

File metadata and controls

103 lines (61 loc) · 9.36 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
Add, remove nodes Failover Cluster Instance
This article shows you how to add or remove nodes in an existing SQL Server Always On failover cluster instance.
MashaMSFT
mathoma
12/13/2019
sql
failover-cluster-instance
how-to
adding nodes
nodes [Faillover Clustering], removing
nodes [Faillover Clustering], adding
failover clustering [SQL Server], nodes
deleting nodes
cluster maintenance [SQL Server]
removing nodes

Add or remove nodes in a failover cluster instance (Setup)

[!INCLUDE SQL Server]

Use this procedure to manage nodes to an existing [!INCLUDEssNoVersion] failover cluster instance.

To update or remove a [!INCLUDEssNoVersion] FCI, you must be a local administrator with permission to log in as a service on all nodes of the underlying Windows Server failover cluster (WSFC). For local installations, you must run Setup as an administrator. If you install [!INCLUDEssNoVersion] from a remote share, you must use a domain account that has read and execute permissions on the remote share.

To add a node to an existing [!INCLUDEssNoVersion] FCI, you must run [!INCLUDEssNoVersion] Setup on the node that is to be added to the [!INCLUDEssNoVersion] failover cluster instance. Do not run Setup on the active node.

To remove a node from an existing [!INCLUDEssNoVersion] FCI, you must run [!INCLUDEssNoVersion] Setup on the node that is to be removed from the [!INCLUDEssNoVersion] failover cluster instance.

To view procedural steps to add or remove nodes, select one of the following operations:

Important

The operating system drive letter for [!INCLUDEssNoVersion] install locations must match on all the nodes added to the [!INCLUDEssNoVersion] failover cluster instance.

Add Node

To add a node to an existing [!INCLUDEssNoVersion] failover cluster instance

  1. Insert the [!INCLUDEssNoVersion] installation media, and from the root folder, double-click Setup.exe. To install from a network share, navigate to the root folder on the share, and then double-click Setup.exe.

  2. The Installation Wizard will launch the [!INCLUDEssNoVersion] Installation Center. To add a node to an existing failover cluster instance, click Installation in the left-hand pane. Then, select Add node to a [!INCLUDEssNoVersion] failover cluster.

  3. The System Configuration Checker will run a discovery operation on your computer. To continue, select OK.

  4. On the Language Selection page, you can specify the language for your instance of [!INCLUDEssNoVersion] if you are installing on a localized operating system and the installation media includes language packs for both English and the language corresponding to the operating system. For more information about cross-language support and installation considerations, see Local Language Versions in SQL Server.

    To continue, click Next.

  5. On the Product key page, specify the PID key for a production version of the product. Note that the product key you enter for this installation must be for the same [!INCLUDEssNoVersion] edition as that which is installed on the active node.

  6. On the License Terms page, read the license agreement, and then select the check box to accept the licensing terms and conditions. To help improve [!INCLUDEssNoVersion], you can also enable the feature usage option and send reports to [!INCLUDEmsCoName]. To continue, click Next. To end Setup, click Cancel.

  7. The System Configuration Checker will verify the system state of your computer before Setup continues. After the check is complete, click Next to continue.

  8. On the Cluster Node Configuration page, use the drop-down box to specify the name of the [!INCLUDEssNoVersion] failover cluster instance that will be modified during this Setup operation.

  9. On the Server Configuration - Service Accounts page, specify login accounts for [!INCLUDEssNoVersion] services. The actual services that are configured on this page depend on the features you selected to install. For failover cluster instance installations, account name and startup type information will be pre-populated on this page based on settings provided for the active node. You must provide passwords for each account. For more information, see Server Configuration - Service Accounts and Configure Windows Service Accounts and Permissions.

    Security Note [!INCLUDEssNoteStrongPass]

    When you are finished specifying login information for [!INCLUDEssNoVersion] services, click Next.

  10. On the Reporting page, specify the information you would like to send to [!INCLUDEmsCoName] to improve [!INCLUDEssNoVersion]. By default, option for error reporting is enabled.

  11. The System Configuration Checker will run one more set of rules to validate your computer configuration with the [!INCLUDEssNoVersion] features you have specified.

  12. The Ready to Add Node page displays a tree view of installation options that were specified during Setup.

  13. Add Node Progress page provides status so you can monitor installation progress as Setup proceeds.

  14. After installation, the Complete page provides a link to the summary log file for the installation and other important notes. To complete the [!INCLUDEssNoVersion] installation process, click Close.

  15. If you are instructed to restart the computer, do so now. It is important to read the message from the Installation Wizard when you are done with Setup. For more information about Setup log files, see View and Read SQL Server Setup Log Files.

Remove Node

To remove a node from an existing [!INCLUDEssNoVersion] failover cluster instance

  1. Insert the [!INCLUDEssNoVersion] installation media. From the root folder, double-click setup.exe. To install from a network share, navigate to the root folder on the share, and then double-click Setup.exe.

  2. The Installation Wizard launches the [!INCLUDEssNoVersion] Installation Center. To remove a node to an existing failover cluster instance, click Maintenance in the left-hand pane, and then select Remove node from a [!INCLUDEssNoVersion] failover cluster.

  3. The System Configuration Checker will run a discovery operation on your computer. To continue, select OK.

  4. After you click install on the Setup Support Files page, the System Configuration Checker verifies the system state of your computer before Setup continues. After the check is complete, click Next to continue.

  5. On the Cluster Node Configuration page, use the drop-down box to specify the name of the [!INCLUDEssNoVersion] failover cluster instance to be modified during this Setup operation. The node to be removed is listed in the Name of this node field.

  6. The Ready to Remove Node page displays a tree view of options that were specified during Setup. To continue, click Remove.

  7. During the remove operation, the Remove Node Progress page provides status.

  8. The Complete page provides a link to the summary log file for the remove node operation and other important notes. To complete the [!INCLUDEssNoVersion] remove node, click Close. For more information about Setup log files, see View and Read SQL Server Setup Log Files.

See Also

View and Read SQL Server Setup Log Files