Active Directory

Need to create 2 AD objects.

  • Cluster Host
  • Listener Host

Object needs to be…

  • In the same AD folder.
  • Add self, cluster, all customer hosts to the security tab with full control.
  • Set the object to “Inactive” state. Inactive account.
  • IP address will be enterer in at setup time. No need to add DNS entry.
  • Login account used needs to be domain admin.

SQL Server

Enable Failover Cluster in SQL Server Configuration Manager. Right click on SQL Server service -> Always On tab -> Check enable failover cluster.

May need to restart the server.

Use Always On folder to open up wizard to create Availability Group.

Note:

  • SQL Server Standard Edition can only allow one database per AG group.
Last modified: March 8, 2023

Author

Comments

Write a Reply or Comment