Building a SQL Server 2008 R2 Cluster: Part V


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.

image

From the drop-down menu click on Configure Cluster Quorum Settings to change the quorum configuration setting.

image

The Configure Cluster Quorum wizard will appear, click on Next to continue further.

image

On the Quorum configuration page, select No Majority: Disk Only and click on Next to continue.

image

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.

image

Confirm the quorum setting and click on Next to continue.

image

Once the quorum is configured, you will get the Summary page, click on Finish to complete the quorum re-configuration.

image

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:

image

The Add Node wizard begins, click on Next to continue.

image

Select the node which we are going to add to the cluster, in our case, BLRC101.

image

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.

image

Confirm the details of the node you are going to add, and click on Next to continue.

image

The node is getting added to the cluster BLR102C.

image

Once the node is added, you will get the following screen. Click on Finish to complete the wizard.

image

If you expand the Nodes in Failover Cluster Management, you will find both the nodes, BLRC100 & BLRC101.

image

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.

About these ads

About Sudeepta Ganguly

A SQL Server User... Still Learning
This entry was posted in Clustering, How To, SQL Server, SQL Server HA, SQL Server Installation and tagged , , . Bookmark the permalink.

5 Responses to Building a SQL Server 2008 R2 Cluster: Part V

  1. Pingback: Review of My Blog by WordPress for year 2010 | SQL…. Still Learning

  2. George says:

    You have me hooked, so when is the part VI coming out….. looking forward to it.

  3. Pingback: Building a SQL Server 2008 R2 Cluster: Part VIII | SQL…. Still Learning

  4. Pingback: Building a SQL Server 2008 R2 Cluster: Part VI | SQL…. Still Learning

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s