Sunday, July 16, 2017

SQL Server 2016 AG Setup Part 2–SQL Node Installation and FCI Configuration

  • Install Windows 2016 Server on SQL Node1(hostname SQL01) and Node2 (hostname SQL02)
  • Configure IP Address, add server to the domain, as well as disable firewall

VirtualBox_SQL01_15_07_2017_10_20_44VirtualBox_SQL01_15_07_2017_10_21_14

Login server using Domain account instead of local admin account

VirtualBox_SQL01_15_07_2017_10_24_42VirtualBox_SQL01_15_07_2017_10_40_33VirtualBox_SQL01_15_07_2017_10_40_51VirtualBox_SQL01_15_07_2017_10_43_05

  • Configure Windows Failover Clustering
VirtualBox_SQL01_15_07_2017_10_52_16VirtualBox_SQL01_15_07_2017_10_52_47
VirtualBox_SQL01_15_07_2017_10_53_19

Since fileshare instead of block storage attached, will skip the storage related testing

VirtualBox_SQL01_15_07_2017_10_53_37
VirtualBox_SQL01_15_07_2017_10_54_21VirtualBox_SQL01_15_07_2017_10_54_26VirtualBox_SQL01_15_07_2017_10_54_34VirtualBox_SQL01_15_07_2017_10_58_24VirtualBox_SQL01_15_07_2017_10_58_33VirtualBox_SQL01_15_07_2017_10_58_49VirtualBox_SQL01_15_07_2017_10_59_22VirtualBox_SQL01_15_07_2017_10_59_38VirtualBox_SQL01_15_07_2017_11_00_13VirtualBox_SQL01_15_07_2017_11_02_21

Ensure Computer account WinCluster$ has read/write access on the cluster share

InkedVirtualBox_PEGAAD_15_07_2017_11_05_01_LI

InkedVirtualBox_SQL01_15_07_2017_11_02_27_LI

VirtualBox_SQL01_15_07_2017_11_02_45VirtualBox_SQL01_15_07_2017_11_02_52VirtualBox_SQL01_15_07_2017_11_03_00VirtualBox_SQL01_15_07_2017_11_03_45VirtualBox_SQL01_15_07_2017_11_05_17VirtualBox_SQL01_15_07_2017_11_05_24VirtualBox_SQL01_15_07_2017_11_05_32