Skip to content
Home » How to Add a Node in SQL Server Failover Cluster

How to Add a Node in SQL Server Failover Cluster

In my previous article in the failover Cluster Instance (FCI) category, I share with you the steps to failover the roles/resources to another node. In this article, we will discuss the steps to add a new node to an existing Windows Server failover cluster (WSFC).

Open the failover cluster manager and connect to the Windows cluster. Right-Click on the Nodes and click Add Node.

Windows Server failover cluster

A new wizard will display as shown in the below screenshot. Click on the browse button to open a new small window.

Add a node to failover cluster

Enter the hostname of the new server which you want to add to the cluster. Click on the “Check Names” button to confirm the hostname and then click the OK button.

add a node to a cluster

Click on the Next button.

add a node to a windows cluster

In the next screen, you will see two options for the Cluster validation “Yes” and “No”. If you choose the “Yes” option, a cluster validation test will perform and will return the control to this wizard after the validation test. When you choose the “No” option, the cluster validation test will not perform and the control will stay on the same wizard as shown below. Click on the Next button.

add a server to failover cluster

In the next screen, you are ready to add the node to the cluster. You can select the checkbox to add all the eligible storage to the cluster. If you do not want to add all the eligible storage at this time, keep it unchecked. Click on the Next button to start adding the node to the cluster.

Add node to existing WSFC

You will see a progress bar when the cluster attempts to add new node to the cluster.

Adding new node to FCI

Once the node is added successfully, you will receive the successful message as shown in the below screenshot. Click on the Finish button to close the wizard.

Add a new node

In the failover cluster manager, click on the Nodes and you will see newly added node to the cluster.

Windows Server failover cluster