Install and Configure MS SQL on a Failover Cluster

1. Configure a share drive (example - E: Drive) and install it on the cluster nodes

2. To configure Failover Cluster, open Failover Cluster Manager. Click on Create a Cluster from the Actions menu tab.

Figure 4: Failover Cluster Manager window

3. On the Before You Begin page, click Next

4. Enter the first cluster node name in the Enter Server Name field and click Add

5. Enter the second cluster node name in the Enter Server Name field and click Add

6. Click Next

7. Enter the Cluster Name and click Next until you reach the Summary page

Figure 5: Create Cluster Wizard window

8. To perform the validation tests, chose Yes and click Next two times

9. Keep the default option to Run all tests and click Next two times

10. Verify the test report and click Finish

11. Provide the cluster name and click Next until you reach the Summary page

12. Verify the cluster got configured successfully. Check the status of the nodes, disk, and network. It should be in green