Configuring Windows clustering

Configuring Windows clustering is required for Microsoft SQL database clustering.

To configure Windows clustering:

1. Install the failover clustering role:
   1. In Server Manager on the DBSRV-1 server, on the Manage menu, click add Roles and Features.
   2. Proceed to the Features page. Select Failover Clustering. Click Install.
   3. Reboot the server.
   4. Repeat steps a-c on the DBSRV-2 server.
2. Validate the cluster configuration:
   1. On the DBSRV-1 server, go to Tools > Failover Cluster Manager.
   2. Before creating a cluster, click Validate Configuration.
   3. Add the desired servers' names to the cluster list. In this example, DBSRV-1 and DBSRV-2 will be joined to a single cluster. These servers are added for validation. Click Next.
   4. Select Run all tests. Click Next.
   5. Ensure that there are no errors in the tests run and that the test report detected the virtual disk that you created in Configuring iSCSI virtual disks.
3. Click Create Cluster.
4. Proceed through the wizard. On the Access Point for Administering the Cluster page, enter a name for your Windows cluster in the Cluster Name field. Provide a virtual IP address to tie to your Windows cluster. Click Next and complete the wizard to create the cluster.

   

5. Go to Storage > Disks, and click Add Disk.
6. The disk that you created in Configuring iSCSI virtual disks displays. Select the disk.
7. Verify the configuration:
   1. Go to Nodes. Ensure that the nodes' statuses display as up.
   2. Go to Storage > Disks. Ensure that the disk status shows as online.

      

   3. On the Active Directory server, you can see that a computer account was created and that it is tied to the Windows virtual IP address.