Build a SQL Cluster Lab Part 4

[ryanjadams]

You are going to create a SQL Server Failover Cluster Instance in Part 4 of our series on how to build a SQL Cluster Lab. The FCI will only be installed on Node1 and Node2. FCIs require shared storage so you will make your domain controller an iSCSI target. Last you will create your FCI using the iSCSI drives you presented to the cluster. Here are links to the other articles in the series.

• Part 1 - Building the environment. Hyper-v VMs, Active Directory, DNS, and Routing and Remote Access Services
• Part 2 - Windows Failover Clustering. Cluster validation, networks, and quorum
• Part 3 - Availability Group. Dedicated network and AD permissions
• Part 4 - Failover Cluster Instance. Creating shared storage using iSCSI and adding the storage to the cluster.

Network Configuration

Here is the list of IP addresses from Part 1 that you will need to configure the SQL Server FCI.

	Data Center 1 IP	Data Center 2 IP
Cluster	10.0.0.10	172.16.0.10
AG Listener	10.0.0.11	172.16.0.11
FCI	10.0.0.15	N/A

 

Architecture

As a refresher, here is the diagram of the lab you are building.

Build Failover Cluster Instance Video