Lets have an idea about the my demo environment
Step by step installation and configuration of SQL server 2016 cluster
- Install Hyper-v,Failover Clustering,Multipath i/o and .net Framwork 3.5 features both SQL Cluster Nodes.
- Create NIC Teaming,Create Converged Network and Configure ip Address on all four NICs.
- Creating Hghly Available sTORAGE ON Star Wind Virtual SAN.
- Enable MPIO and restart Both Cluster Nodes.
- Discovering Iscsi Target and disk to Booth Cluster Nodes.
- Creating a windows Fail over Cluster and Modify cluster Disk & Networking Seetings.
- Install SQL Server 2016 Failover Cluster on SQL-Node01.
- Verify SQL Server Role on Windows failover Cluster.
- Add Second Node on SQL Server 2016 cluster (install SQL Server 2016 on Node-SQL02)
Now i am going to add feature manager add Rowland features and click next .
Select Hyper-V and failover cluster , botnet framework 3.5 ,and next
Installation progress
IP Address Configuration for Cluster Nodes
| Server Name | Domain-vNIC | iscsi-vNIC | Cluster-vNIC | Live Migration-vNIC | Subnet Mask |
| SQL-Node01 | 192.168.1.201 | 10.10.10.201 No Gateway/DNS | 192.168.2.201 no Gateway/DNS | 192.168.3.201 no Gateway/DNS | 255.255.255.0 |
| SQL-Node02 | 192.168.1.202 | 10.10.10.202 no Gateway/DNS | 192.1868.2.202 no Gateway/DNS | 192.168.3.202 NO Gateway/DNS | 255.255.255.0 |
Create NIC Teaming, Create Converged Network and configure IP Address on all four NICs.
Creating Highly Available Storage on star Wind virtual SAN
Enable MPIO and restart Both Cluster Nodes
Next
next
Discovering iscsi Target and Add disk to Both Cluster Nodes
Next
Next
Next
Creating a Windows Fail over Cluster and Modiy Cluster Disk&Network Settings
Next
Next
Next
Next
Next
Verify SQL Server Cluster Role on Windows failover Cluster
next
Add Second Node on SQL Sever 2016 cluster (install SQL server 2016 on node- SQL02)
