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.
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.
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!