Building a SQL 2012 Always-On Cluster – Part 2
In my previous article “Building a SQL 2012 Always-On Cluster – Part 1” we examined the deployment of a SQL Server 2012 by deploying the first cluster node. The idea was to explore both the process of SQL Server 2012 clustering for a failover cluster, but also to see how different the installation process might be from Windows Server 2008 R2. In the initial deployment the process did not seem much different at all, although there are many other differences in the product features themselves.
In this article we will explore the process of adding a second node to the cluster that was already deployed.
As with the deployment of the first node, please ensure that all your rre-requisites are met in relattion to the node setup, software versions and hardware configuration.
On your second node, execute the SQL Server installation and process the Setup Support Rules and validation. (As mentioned before, please ensure that you have validated the Windows Fail-over Cluster).
Step 1: Complete the SQL Server validation and remediate any errors.
Step 2: From the listed provided, select the SQL Server cluster you wish to add a node to.
Step 3: On the selected cluster, select the SQL Server virutal IP address that should be used for this node.
The rest of the installation will validate the node against the required SQL Server features selected and complete the installation. (Simple right).