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

70-462-23

FIGURE 8-5 Installing the Failover Clustering feature

To configure a failover cluster, perform the following steps:

  1. 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.
  1. In the Failover Cluster Manager console, click Create A Cluster in the Actions menu.
  2. On the Select Servers page, shown in Figure 8-6, enter the names of the nodes that will participate in the cluster.

70-462-24

FIGURE 8-6 Selecting cluster nodes

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

  1. On the Access Point For Administering The Cluster page, enter a name and IP address of the cluster, as mentioned in Figure 8-7.

70-462-25

FIGURE 8-7 Cluster administration point

  1. On the Confirmation page, verify the settings and click Next to have the wizard create the cluster.