Installing and Configuring a SQL Server 2014 Multi-Subnet Cluster on Windows Server 2012 R2
This document contains a step-by-step guide for installing and configuring a 2-node Windows Server 2012 R2 Failover Cluster that will host a SQL Server 2014 multi-subnet failover clustered instance. It is intended for experienced Windows system administrators, IT professionals, and SQL Server database administrators, and provides detailed instructions on installation, configuration, and initial steps working with StarWind Virtual SAN as the underlying storage subsystem.
A SQL Server 2014 multi-subnet failover clustered instance is a configuration where each node of the cluster is connected to a different network subnet or subnets, which can be in the same location or in a remote site commonly used for disaster recovery. This configuration provides the benefit of having both high availability and disaster recovery solution meeting business' recovery objectives for SQL Server 2014 databases.
- Windows Server 2012 R2 is installed on each server that will be used for the cluster and that they are joined to the same Active Directory domain.
- The iSCSI storage is configured as per the StarWind’s Hyperconverged Scenario Basic 2-Node Setup document. It is assumed that the highly available, fault tolerant storage is already made available prior to configuring the servers for the failover cluster.
- Quorum model has been chosen. This document will use the disk witness as the quorum model.
There are two domain controllers - DC1 and DC2 - in the same Active Directory domain. The domain controllers are in different network subnets, each on a dedicated Active Directory site and configured for replication. Cluster nodes SQLCLUSTER1 and SQLCLUSTER2 have four network adapters - one for production traffic, one for heartbeat communication and two for the iSCSI storage. Storage system SAN1 is being replicated over to SAN2 via a TCP/IP connection.
Installation and Configuration steps:
- Adding Required Windows Features
- Discovering Target Portals
- Connecting Targets and Configuring Multipathing
- Initialize and Format the Disks
- Verify the Storage Replication Process
- Running the Failover Cluster Validation Wizard
- Creating the Windows Server 2012 R2 Multi-Subnet Cluster
- Tuning Cluster Heartbeat Settings
- Install SQL Server 2014 on a Multi-Subnet Failover Cluster
- Adding a Node on a SQL Server 2014 Multi-Subnet Cluster
- Tuning the SQL Server 2014 Failover Clustered Instance DNS Settings
- Testing Application Connectivity