I was going to create a Windows Server Failover Cluster, in order to set up MS SQL Server AlwaysOn Availability Groups.
As a prerequisite of failover clustering, I've created and configured an Active Directory using two servers. One server is domain controller, another server is the member of the domain.
While following all the steps and suggestions of creating a failover clustering, I've found that all the nodes should be in the same Domain Role
. As long as I understand, the domain must have at least one domain controller. And in order to create a meaningful Failover Cluster, there should be 2 or more nodes. This means that I need three server to setup a basic failover clustering with 2 nodes? One is domain controller, which is not going to participate in the clustering, and 2 others are domain members and are nodes of the failover cluster?
On other article, about Sql Server AlwaysOn availability group perquisites, the system/server/computer should not be a domain controller, but all the nodes should be domain members.
Ok, then I need three servers to setup two node (one primary, and one secondary replica) Sql Server AlwaysOn Availability Groups on top of a two node Failover Clusters (two domain members, and 1 domain controller)? How is that? Or I'm missing something, or it can be configured with only tow servers somehow?
Thanks.