The first step in creating a Windows Server 2008 R2 failover cluster to host a SQL Server 2012 failover cluster is to install the Failover Clustering feature. You can do this through the Server Manager console, as shown in Figure 8-5, or by using the following Windows PowerShell command when the ServerManager module is loaded: Add-WindowsFeature Failover-Clustering
FIGURE 8-5 Installing the Failover Clustering feature
To configure a failover cluster, perform the following steps:
- When you have connected each potential node to the shared storage device and installed the Failover Clustering feature, open the Failover Cluster Manager from the Administrative Tools menu.
- In the Failover Cluster Manager console, click Create A Cluster in the Actions menu.
- On the Select Servers page, shown in Figure 8-6, enter the names of the nodes that will participate in the cluster.
FIGURE 8-6 Selecting cluster nodes
- Choose whether to perform validation tests.
MORE INFO: VALIDATION TESTS
Although validation tests are necessary only if you want Microsoft to support the cluster configuration, you should use the tests to identify any potential deviation from best practice.
- On the Access Point For Administering The Cluster page, enter a name and IP address of the cluster, as mentioned in Figure 8-7.
FIGURE 8-7 Cluster administration point
- On the Confirmation page, verify the settings and click Next to have the wizard create the cluster.