Breadcrumbs

Install and Configure MS SQL on a Failover Cluster

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

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

404ae48b-829c-4279-864f-c0db6edf9e2c.jpg


"Failover Cluster Manager" Window

  1. On the Before You Begin page, click Next.

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

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

  4. Click Next.

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

2954b674-6b4c-4428-b308-1936fe9e5c9f.jpg


"Create Cluster Wizard" Window

  1. To perform the validation tests, choose Yes and click Next two times.

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

  3. Verify the test report and click Finish.

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

  5. Verify that the cluster was configured successfully. Check the status of the nodes, disk, and network. It should be in green.