Install sequence for SQL 2016 AlwaysOn AG's on Standard Edition

• Express12

  SSCoach

  Points: 18514

  More actions

  October 18, 2017 at 11:40 am

  #324208

  What is s/w install sequence for creating brand new SQL 2016 Standard edition AlwaysOn Availability Group(s):   

  Is it possible to do this:

  Create 2 brand new machines each w/ Windows Server 2016
  Install Windows Failover cluster -- adding both nodes to the cluster
  Install SQL standard edition on machine 1 -- as standlone (NOT adding as a NODE to a cluster)
  Install SQL standard edition on machine 2 -- as standlone (NOT adding as a NODE to a cluster)
  Then configure AlwaysOn AG's via SQL Server Configuration Manager, etc?

  BT

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  October 19, 2017 at 12:59 am

  #1964313

  Pretty much yes that's the order.

  Remember the limitations with Standard edition for AOAG's as BAG's have limitations, like 1 database per BAG, no Read Only Secondary etc.

  For more info on the intricacies of Always On, I would recommend Perry's stairway http://www.sqlservercentral.com/stairway/112556/