How to Install & Configure SQL Server 2016 Failover Cluster Step By Step

Hello friends

1. Install Hyper-V Failover Clustering Multipath I/O and .Net Framework 3.5 features both SQL Cluster Nodes.
2. Create NIC Teaming Create Converged Network and Configure IP Address on all four NICs.
3. Creating Highly Available Storage on StarWind Virtual SAN.
4. Enable MPIO and restart Both Cluster Nodes.
5. Discovering iSCSI Target and Add disk to Both Cluster Nodes.
6. Creating a Windows Fail Over Cluster and Modify Cluster Disk & Network Settings.
7. Install SQL Server 2016 Failover Cluster on SQL-Node01.
8. Verify SQL Server Cluster Role on Windows failover Cluster.
9. Add Second Node on SQL Sever 2016 Cluster (Install SQL Server 2016 on Node-SQL02).

# Script written by Vikas Singh
# Powershell Script To Create Converged Fabris For Clusterd Windows Server 2012 Hyper-V Host
# This Script creates 4 Virtual NICs for Domain iSCSI Cluster and Live Migration.

# "Converged-vNIC" is Team Name for NICs teaming.
New-VMSwitch “Converged-vSW” -MinimumBandwidthMode weight -NetAdapterName “Converged-vNIC” -AllowManagementOS 0
Set-VMSwitch “Converged-vSw” -DefaultFlowMinimumBandwidthWeight 10
Add-VMNetworkAdapter -ManagementOS -Name “Domain-vNIC” -SwitchName “Converged-vSW”
Set-VMNetworkAdapter -ManagementOS -Name “Domain-vNIC” -MinimumBandwidthWeight 10
Add-VMNetworkAdapter -ManagementOS -Name “iSCSI-vNIC” -SwitchName “Converged-vSW”
Set-VMNetworkAdapter -ManagementOS -Name “iSCSI-vNIC” -MinimumBandwidthWeight 10
Add-VMNetworkAdapter -ManagementOS -Name “Cluster-vNIC” -SwitchName “Converged-vSW”
Set-VMNetworkAdapter -ManagementOS -Name “Cluster-vNIC” -MinimumBandwidthWeight 10
Add-VMNetworkAdapter -ManagementOS -Name “LiveMigration-vNIC" -SwitchName “Converged-vSW”
Set-VMNetworkAdapter -ManagementOS -Name “LiveMigration-vNIC" -MinimumBandwidthWeight 10

Thank You
Vikas Singh

sql server 2016
sql server 2016 alwayson
sql server 2016 alwayson availability groups
sql server 2016 alwayson availability groups step by step
sql server 2016 availability groups
sql server 2016 backup
sql server 2016 cluster installation
sql server 2016 clustering step by step
sql server 2016 configuration
sql server 2016 download and install
sql server 2016 evaluation edition
sql server 2016 failover cluster
sql server 2016 failover cluster installation
sql server 2016 failover cluster step by step
sql server 2016 filestream
sql server 2016 high availability
sql server 2016 how to install
sql server 2016 how to install management studio
sql server 2016 installation
sql server 2016 installation media
sql server 2016 installation on windows server 2012 r2

[TheLRDad]

Terrific guide. The fact that you get right to the point is very much appreciated. Continue to make more!

[abulaith]

Thank you for dedicating your time to show how clustering works. Excellent!

[cristidanie]

even in 2020 this post is still useful ... many thanks bro ... keep up with the good job

[nikhilpatel]

Excellent explanation Sir! your tutorial has helped me lot to write the automation for installing sql server failover cluster active-passive mode using ansible. Thanks you once again !

[KoratNextGENClub]

Great Sir, ease understand and explain. save our time to curve learning a SQL Clustering.

[JohnTamakloe]

woow.. Been looking for something like this for weeks... you

[raufmedappil]

Brother excellent work..Keep it up..👏.
Should NIC teaming be done the same way you did here, if 2 nodes are actually 2 physical servers??

That part was little tricky to me

[arielcruz]

EXCELLENT Video Training!! Thank you!

[antem.]

Thank you Sir. This is very helpful video.

[cristobalsb]

Very detailed explanation, very well done!

[benelcaidredouane]

Hi,

Nice to see you are recreating your videos for windows server 2016.

Why people dont use groupe managed service account in their step by step, it's more secure et easier ? (maybe not easier but you dont have to manage service account password anymore)

btw you should do a step by step for this too (gMSA for SQL) its a great idea

[suhrob]

Thanks you very much, I found it very helpful!

[doctordey]

thanks for teaching, it is really helpful.
but unfortunately i do not have access to any other node or domain controller using as a ISCSI target server, is there any other way to do clustering without having a 3rd server involvement as a ISCSI Target server ... Please Answer

[manusysadmingeek]

Hi, I have a query. I see that you use vmware to create your virtual machines, but it is not clear to me how you did so that the different networks could be seen. I ask this because there is a part where you configure storage that I understand it is necessary know each other

when you use the startwind software it is not clear to me how you have configured the vmware network and what host is raising the resource because it is not detailed in the diagram

Thank you

[jarves]

in your video you have starwind installed on another server to act as vsan?

[trieutruong]

Dear sir,


why do we need to install hyper-V role in both Cluster-node?
I was trying to think of about this case several times.

Hi, we are using cluster due to unexpected restart of data centre now SQL node 1 is working fine but on node 2 SQL server service s not running.error 1067 .The process terminated unexpectedly.

[hugohew]

Hi I tried to create the NIC Teaming the error is "The only valid LoadBalancingAlgorithms in a Virtual Machine are 'TransportPorts', 'IPAddresses', and 'MacAddresses" how to resolve this?

[iampaddyofficial]

As you have setup the failover cluster on SQL-Node01 VM and let say that VM crashes then how will you be able to migrate to SQL-Node02, if you won't be able to connect or RDP SQL-Node01? Should we setup the cluster on a separate VM?

[supportteam]

If we are using physical SAN storage with fiber FC, is it required to install MPIO and iscsi virtual network?