SQL Cluster Node - Showing as down

Ben 11 Reputation points
2020-12-01T15:02:01.883+00:00

I have a 2 node failover cluster with 2 SQL VM's in. one is showing as down, the services are running however in the cluster manager it says that the networks are down however i can ping them, rdp to them etc etc I've tried rebooting both servers in the cluster and that didnt have an effect. unsure whethger to evict the server and re-add it?

the quorum is online, the cluster IP address pings the sql server in question has all the correct services running and there are a number of errors in the cluster event viewer

  • Cluster failed to start (5398)
  • Cluster node failed to join cluster as it could not communicate over the network with any other node in the cluster (1653)
  • Node failed to firm a cluster this was because witness was not accessible (1573)
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,642 questions
Hyper-V
Hyper-V
A Windows technology providing a hypervisor-based virtualization solution enabling customers to consolidate workloads onto a single server.
2,530 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.
956 questions
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Xiaowei He 9,866 Reputation points
    2020-12-02T09:29:07.52+00:00

    Hi,

    Do you mean the Cluster node unable to start cluster service, if yes, we may try to evict the cluster node, then check if the NIC on the node is well and if the NIC driver is up to date, if not, please try to update the NIC driver. Then try to re-add the Cluster node into the cluster.

    If we meet issue to re-add the Cluster nodes, please run PowerShell command "Get-clusterLog" then check the detailed log when adding the cluster node.

    https://learn.microsoft.com/en-us/powershell/module/failoverclusters/get-clusterlog?view=win10-ps

    Thanks for your time!
    Best Regards,
    Anne

    -----------------------------

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Ben 11 Reputation points
    2020-12-02T13:41:59.52+00:00

    Hi, There is 2 virtual SQL servers in a SQL cluster but then also a failover cluster for the VM's in the failover cluster manager MMC console it shows both NICs as offline however I am to connect to both the connections as well as pinging from the other node. I was thinking of evicting the node but was not sure of the concequences involved in that, is it simple as just evicting and then add a role and re-add the server?

    The drivers for Hyper-V are up to date as far as i can tell.

    0 comments No comments

  3. Ben 21 Reputation points
    2020-12-11T13:52:07.787+00:00

    is there any further advise on this?


  4. Xiaowei He 9,866 Reputation points
    2020-12-15T02:35:14.363+00:00

    Hi,

    In addition, if we have some issues with the network communication between the two nodes, after evicting the node from the cluster, we may also have issues to re-add the node into the cluster.

    However, when the node fails to add to the Cluster, we may get more detailed logs about the issue, this is why I suggest getting the cluster log to check more detailed information.

    Best Regards,
    Anne

    0 comments No comments