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

Question

Answer 1

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

Answer 2

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.

Answer 3

Hey,

Did you run the SQL Server Setup on the node you are trying add? Make sure that you have configured all the accounts and permissions. https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?view=sql-server-ver16

Might also help: https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/install/add-or-remove-nodes-in-a-sql-server-failover-cluster-setup?view=sql-server-ver16#Add

https://www.starwindsoftware.com/resource-library/starwind-virtual-san-installing-and-configuring-sql-server-2019-tp-failover-cluster-instance-on-windows-server-2016/

Cheers,

Alex Bykovskyi

StarWind Software

Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.