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

Applies to: SQL Server

Use this procedure to manage nodes to an existing SQL Server failover cluster instance.

To update or remove a SQL Server 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 SQL Server 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 SQL Server FCI, you must run SQL Server Setup on the node that is to be added to the SQL Server failover cluster instance. Do not run Setup on the active node.

To remove a node from an existing SQL Server FCI, you must run SQL Server Setup on the node that is to be removed from the SQL Server 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 SQL Server install locations must match on all the nodes added to the SQL Server failover cluster instance.

Add Node

To add a node to an existing SQL Server failover cluster instance

  1. Insert the SQL Server 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 SQL Server 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 SQL Server 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 SQL Server 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 SQL Server 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 SQL Server, you can also enable the feature usage option and send reports to Microsoft. 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 SQL Server failover cluster instance that will be modified during this Setup operation.

  9. On the Server Configuration - Service Accounts page, specify login accounts for SQL Server 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 Do not use a blank password. Use a strong password.

    When you are finished specifying login information for SQL Server services, click Next.

  10. On the Reporting page, specify the information you would like to send to Microsoft to improve SQL Server. 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 SQL Server 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 SQL Server 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 SQL Server failover cluster instance

  1. Insert the SQL Server 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 SQL Server 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 SQL Server 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 SQL Server 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 SQL Server 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