Share via

Issue on Creating failover cluster

kedar giri 61 Reputation points
2024-06-27T15:54:54.7833333+00:00

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.’'nmb

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,203 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,518 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
973 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ian Xue (Shanghai Wicresoft Co., Ltd.) 33,301 Reputation points Microsoft Vendor
    2024-06-28T02:49:33.3566667+00:00

    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.