SQL Server 2014 Failover Cluster

Prerequisites

  1. 1 VM For DC Server 
  2. 1 VM For iSCSI Target Server
  3. 2 VM For SQL Server Node 1 and SQL Server Node 2

VMs

 Architecture

Storage iSCSI Target Server Installation

  • Open Server Manager
  • Add roles and featuresScreenshot (27)
  • Role-based or feature-based installation and click Next
  • Server Roles and then select iSCSI Target Server to enable iSCSI target server role
  • Next
  • Features: Click Next
  • Confirmation: Click Installation
  • RestartScreenshot (28)

Configure iSCSI Server 

  • Open Server Manager and click File and Storage Services and then click iSCSI
  • Select New iSCSI Virtual DiskScreenshot (68)
  • iSCSI Virtual Disk Location Select the Volume Drive to create the virtual disk
  • Type the size of the virtual disk and click NextScreenshot (71)
  • Select New iSCSI target and click NextScreenshot (70)
  • Type the name of the new Target Server and click NextScreenshot (72)
  • Click Add to add an initiator and click Next
  • Add Node 1 and Node 2 as Initiators.Screenshot (74)
  • Enable authentication: Click Next
  • Confirmation: Click Create
  • Click CloseScreenshot (76)

Node 1 and Node 2 Initiator Configuration 

  • Open iSCSI Initiator and Click DiscoveryScreenshot (34) 
  • Click Discovery Portal and type the IP address of the iSCSI Target server and click OKScreenshot (35)
  • Click Targets tab and Select the target within the Discovered targets and click Connect
  • Click OK
  • Open Server Manager and click File and Storage Services and then click DisksScreenshot (31)
  • The new disk (Quorum) should be presented as Offline
  • Right click on the disk and select Bring Online and then Click Yes Screenshot (32)
  • Right click on the new disk and select New Volume
  • Select Server and Disk
  • Select the size for the new disk and then click Next
  • Select drive letter and ten Click Next
  • Type the label of the volume (Quorum Disk)
  • Click Create
  • Close

 Setup Windows Server 2012 Failover Cluster

Node 1 and Node 2  Install Failover Clustering

  • Open Server Manager and 
  • Click Add roles and featuresScreenshot (37) 
  • Click Next
  • Select the server on which to install roles and features Select ” Select The 2 Nodes for Installation ” and click NextScreenshot (38)
  • Features: Select  Failover Clustering Click Next
  • Confirmation: Click Installation
  • Restart in necessary

Node 1 and Node 2 Validate and Create Windows Cluster

  • Open Failover Cluster Manager
  • Click Validate Configuration
  • Click NextScreenshot (41) 
  • Select Servers or a Cluster Add the node names Node 1 and Node 2 and click NextScreenshot (43) 
  • Testing Options: Select Run all tests and click Next
  • Confirmation Click NextScreenshot (46)
  • Validating Create the cluster now using the validated nodes is checked and click Finish
  • Click NextScreenshot (48) 
  • Access Point for Administering the Cluster Type the cluster name SQLNodeClu.
  • Type the IP address from the public network.Screenshot (49) 
  • Add all eligible storage to the cluster Click Next
  • FinishScreenshot (50)
  • The New Server failover cluster installed on Node 1 and Node 2 .

Screenshot (57)

Installing SQL Server 2014  as a Clustered Instance on Node 1

Begin SQL Server 2014 installation on the first cluster node.

  • Choose the Installation tab and choose the New SQLServer failover cluster installation

Screenshot (4)

  • Accept the License Terms

Screenshot (6)

  • Failover Cluster rules will be installed. It is essential that this step completes without errors.

Screenshot (8)

  • Choose the SQLServer Feature Installation

Screenshot (9)

  • Select the features.

Screenshot (10)

  • Provide a Network Name for your SQL instance.

Screenshot (12)

  • Specify a name for the SQL Server cluster resource group of proceed with the default.
  •  Proceed with the default Cluster Disk selected

Screenshot (13)Screenshot (15)

  • Choose both the IPv4 and IPv6 networks if available.

Screenshot (16)

  • Configure your SQL Server Agent and Database Engine accounts
  • Specify your SQL Server administrators and choose your authentication mode.

Screenshot (17)

  • Select the Data Directories tab. This allows you to customize the Cluster Shared Volumes paths where you want to store the files corresponding to your SQL Database.

Screenshot (18)

  • Proceed with the final SQL Server installation.

Screenshot (56)     Now add the other cluster nodes to the Failover Clustering Node2

  • choose the Add node to a SQL Server failover cluster option.

Screenshot (22)

  • Accept the Terms.

Screenshot (25)

  •  The Rules check occur and click Next

Screenshot (24)

  • By default Instance Name…, and click Next

1325.27

  • Set IPV4 from the same Subnet Mask and click Next

5164.28

  • Set the Admin Account and specify Password

5468.29

  • Click Install

8053.30

  • Finally the Node Added to the Sql Failover Cluster.

4520.31


Now

  • Open Failover Windows Cluster
  • SQL Server Running
  • 2 Online Nodes

Screenshot (58)

Advertisements

One thought on “SQL Server 2014 Failover Cluster

  1. Pingback: Install SharePoint 2013 on Network Load Balance | Helmy Mohamed

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s