Share via

Always-on on multi-subnet domain independent failover cluster

kedar giri 81 Reputation points
2023-07-23T04:58:15.7633333+00:00

Hello Everyone,

In One of our clients, the is only two windows servers, and our responsibility was to Deploy failover cluster and on top of that we have to deploy always-on on SQL Server, the environment is something like they have SQL-PROD and SQL-DR which are in different subnet, I have deployed Failover cluster and also deployed always on in SQL server. after couple of day the SQL-DR(DR) suddenly shutdown which lead to SQL-Prod (Primary Server) database to inaccessible state. the issue was something like 

The local node is not part of quorum and is unable to initiate a failover. This could be caused by one of the following reasons:

•   The local node is not able to communicate with the WSFC cluster.

•   No quorum set exists across the WSFC cluster.

 For more information on recovering from quorum loss, see SQL Server Books Online.

  (Microsoft.SqlServer.Management.HadrTasks)

After SQL-DR(DR) was UP then, everything went normal, primary server was accessible. what might be the issue??

failover manually does not have any issue but, shutting down lead to the SQL-PROD (Primary) to inaccessible, so what might be the possible solution.

Note: -There is no active directory or DNS servers. There environment is exactly that I have mention above scenario.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,446 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,674 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.
1,025 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. PercyTang-MSFT 12,511 Reputation points Microsoft Vendor
    2023-07-24T08:04:34.12+00:00

    Hi @kedar giri

    Not sure if this post can help you.

    https://geekshangout.com/sql-availability-group-setup-the-local-node-is-not-part-of-quorum/

    Best regards,

    Percy Tang

    0 comments
  2. kedar giri 81 Reputation points
    2023-07-30T08:33:29.06+00:00

    There was no vote majority so we added fileshare witness and problem was resolved

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.