trying to add a node to a SQL cluster and I am getting the following error

Lopez, Hector 0 Reputation points
2024-06-23T21:25:21.79+00:00

User's image

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.
979 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. S.Sengupta 17,236 Reputation points MVP
    2024-06-23T23:52:20.8833333+00:00

    Suggestions:

    Ensure the account used to add the node has administrative privileges on all nodes of the cluster.

    Ensure all nodes can communicate with each other. You can use Ping Command for this.

    Ensure that the firewall settings on all nodes allow necessary ports for SQL Server and clustering.

    Check Cluster Configuration

    Get-ClusterLog -Node <NodeName> -TimeSpan 5 -Destination <Path>
    
    

    Check Cluster Nodes

    Get-ClusterNode
    
    

    Check Cluster Network

    Get-ClusterNetwork
    
    
    0 comments No comments

  2. Ian Xue (Shanghai Wicresoft Co., Ltd.) 34,271 Reputation points Microsoft Vendor
    2024-06-25T02:52:29.3533333+00:00

    Hi Lopez,

    Hope you're doing well.

    Here are some steps you can follow:

    1. Ensure that you're running SQL Server Setup as an administrator on the node you want to add. Verify that you have local administrator permissions on all nodes of the underlying Windows Server failover cluster (WSFC). If installing from a remote share, use a domain account with read and execute permissions on the share¹.
    2. Launch SQL Server Installation Center from the installation media. Click "Installation" in the left-hand pane and select "Add node to a SQL Server failover cluster." The System Configuration Checker will run a discovery operation on your computer. Click "OK" to continue.
    3. The System Configuration Checker will verify your system state before continuing.

    If you encounter any issues, consider checking the SQL Server service credentials and investigating the cause of failure on the first node. Additionally, try running the PowerShell command 'Clear-ClusterNode -Name nodeName -Force' before adding the node back to the cluster.

    Best Regards,

    Ian Xue


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

    0 comments No comments