Active Directory Setup for SQL Server Always On Setup using Failover Cluster

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.