Sunday, July 16, 2017

SQL Server 2016 AG Setup Part 3–SQL AG FCI Cluster Instance installation

  • Preparation work (domain account dbaglobe\sqlsvcs, as well as shared folder permission)
VirtualBox_PEGAAD_15_07_2017_12_09_26
VirtualBox_PEGAAD_15_07_2017_12_09_32
grant read/write permission on \\winad\clustershare\sql to dbaglobe\sqlsvcs
VirtualBox_PEGAAD_15_07_2017_12_15_16
  • Install SQL FCI cluster 1st Node (hostname: SQL01)
VirtualBox_SQL01_15_07_2017_12_04_27
Click “New failover clustering installation”
VirtualBox_SQL01_15_07_2017_12_05_11VirtualBox_SQL01_15_07_2017_12_05_23VirtualBox_SQL01_15_07_2017_12_05_29VirtualBox_SQL01_15_07_2017_12_05_42VirtualBox_SQL01_15_07_2017_12_06_16VirtualBox_SQL01_15_07_2017_12_06_31VirtualBox_SQL01_15_07_2017_12_16_34VirtualBox_SQL01_15_07_2017_12_16_50VirtualBox_SQL01_15_07_2017_12_59_07VirtualBox_SQL01_15_07_2017_12_59_54
  • Preform “Add node to a SQL Server Failover cluster” action
VirtualBox_SQL02_15_07_2017_13_04_59VirtualBox_SQL02_15_07_2017_13_05_37VirtualBox_SQL02_15_07_2017_13_05_46VirtualBox_SQL02_15_07_2017_13_06_10VirtualBox_SQL02_15_07_2017_13_06_36VirtualBox_SQL02_15_07_2017_13_06_55VirtualBox_SQL02_15_07_2017_13_16_33
VirtualBox_SQL01_15_07_2017_13_17_35
  • Post Action: change the port from default dynamic port to non-default port 2443