Buliding a SQL 2008 R2 Cluster: Part VII

In the previous part of this series, we had installed the Failover SQL Cluster. In this post, we are going to add the second node to the existing cluster. To begin with, verify that all the resources are present on the first node. Start the SQL Server setup from the installation media on the second node, and select Add Node to a SQL Server Failover Cluster.

The SQL support files will be installed and the current node is verified for the SQL server installation. Provide the Product-Key and click on Next to continue the installation. Select the SQL Server failover cluster instance name, to which, you want to add the current node, and click on Next to continue further.

Enter the SQL Server Database Engine & SQL Agent Passwords and click on Next to continue further.

Verify all the features need to installed as part of the add-node installation for the Failover SQL Cluster, and click on Install to start the installation. The configuration file can be used for the script based installation for add new node to existing SQL Cluster.

Once the setup is completed successfully, we will get the following screen:

With this post, the series on How to install a Windows Cluster and How to deploy a SQL Server 2008 R2 Failover Cluster is completed. However, this posts are mainly targeted to create a setup for testing / learning purpose. For any production deployment, make sure the Windows Cluster validation wizard passed before proceeding further. Verify Book Online for any additional information. You also need to provide more access for the SQL Server Service Accounts on the drives containing SQL Server files, database files, etc. Make sure the Database Engine Service account has both read and write permissions on the drive, whereas the SQL Agent Service account need read permissions on the drives. Once the cluster is up & running, you might need to configure it as per your requirements, like moving TempDB to a different drive, separate drives for User and System databases, etc.

In real world scenario, we normally never shutdown a cluster; however, you may need it in your lab. If you are deployed the entire failover cluster on a Stand-alone machine as me, then you may need to shut down all the VMs before shutting down your Laptop/Desktop. In the last part of this series, we are going to discuss shutdown the entire cluster in your lab, so that it can be used only when required. Stay tuned!


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.

One Response to Buliding a SQL 2008 R2 Cluster: Part VII

  1. Pingback: Building a SQL Server 2008 R2 Cluster: Part VIII | 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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s