Issue on Creating failover cluster

Question

Hello there “Our client requested the deployment of SQL Server Always On on Windows Server 2019 Standard and SQL Server 2019 Datacenter. We established a failover cluster comprising three domain-joined servers with active directory connectivity. Network communication is operational, and each server’s IP address and hostname are mutually resolvable. However, during the failover validation process for the three nodes (SQL-PRIMARY, SQL-SECONDARY, and SQL-DR), we encountered a specific issue on the SQL-DR node.” The issue we faced is as follows: “Connectivity to a writable domain controller from the node SQL -DR could not be determined due to the error: ‘Could not get domain controller name from machine SQL-DR.’'

Despite encountering this issue, we proceeded with cluster creation. Unfortunately, we have made no progress, and the same issue persists during cluster creation. Ifanyone has experience or insights related to this issue, any suggestions or solutions would be highly appreciated.

Answer 1

Hi Kedar,

Hope you're doing well.

Is the account logged into the cluster node a domain administrator account? If not, log into the cluster node with a domain administrator account and try to create the cluster.

Here're two relevant documents for your reference:

Deploy a domain-independent Windows Failover Cluster for SQL Server Always On Availability Groups (sqlshack.com)

Configure Domain Controller and Active Directory for SQL Server Always On Availability Groups (sqlshack.com)

Best Regards,

Ian Xue

---

If the Answer is helpful, please click "Accept Answer" and upvote it.