In the previous part of this series, we have created the windows cluster and added the disk resources. In this post, we are going to re-configure the Quorum setting of this cluster, and then we are going to add the second node of this cluster.
Configuring the Quorum of the Cluster
When we create a cluster using Windows Server 2008, by default, the quorum is set as Node Majority. However, this feature is not available for a two-node cluster. To change the quorum setting, click on More Actions as shown below.
From the drop-down menu click on Configure Cluster Quorum Settings to change the quorum configuration setting.
The Configure Cluster Quorum wizard will appear, click on Next to continue further.
On the Quorum configuration page, select No Majority: Disk Only and click on Next to continue.
On the select storage resource page, select the disk for the Quorum from the available list of disks. In our case, the Disk 1 is used as a Quorum disk (with drive letter Q). Click on Next to continue further.
Confirm the quorum setting and click on Next to continue.
Once the quorum is configured, you will get the Summary page, click on Finish to complete the quorum re-configuration.
Now that we have re-configured our quorum disk, its time to add the second node of our cluster.
Adding Node to the Cluster
What we have done so far in this series on SQL Server Cluster installation? We have configured the storage server, shared the disks with the cluster nodes, configure the Cluster, added the disk resources, and re-configured the Quorum. Now the only remaining part of this two-node cluster installation is Addition of the second node.
To begin with, open the Failover Cluster Management and connect to the cluster BLR102C and click on Add Node from the menu available on the right-side of the screen as shown below:
The Add Node wizard begins, click on Next to continue.
Select the node which we are going to add to the cluster, in our case, BLRC101.
As there were some warnings in our cluster validation report, we will get the following screen. Since this is for learning purpose, I am not going to contact Microsoft Support for this cluster, so I am continuing to add the node without re-validating the cluster configuration. As mentioned earlier, for the production environment, you should make sure the validation wizard completed successfully.
Confirm the details of the node you are going to add, and click on Next to continue.
The node is getting added to the cluster BLR102C.
Once the node is added, you will get the following screen. Click on Finish to complete the wizard.
If you expand the Nodes in Failover Cluster Management, you will find both the nodes, BLRC100 & BLRC101.
This completes the installation of the Windows Cluster using Windows Server 2008. In the next part of this series, we are going to start the installation of SQL Server in the clustered environment.