Falha ao adicionar node no cluster SQL

Question

Perdemos um dos nodes do cluster, foi necessário reinstalar o SO e ao tentar adicionar o node no cluster SQL novamente, está apresentando a seguinte mensagens.

Windows server 2022

SQL server 2019 Ambiente virtualizado em Vmware

---

Feature failure reason: An error occurred for a dependency of the feature causing the setup process for the feature to fail.

 

Error details: § Error installing SQL Server Database Engine Services Instance Features There was an error to lookup cluster resource types. Error: There was a failure to call cluster code from a provider. Exception message: Generic failure . Status code: 4098. Description: Not found. Error code: 0x86D80018

Answer 1

Hi @Anonymous ,

Thank you for your reaching out and welcome to Microsoft Q&A!

Error: There was a failure to call cluster code from a provider. Exception message: Generic failure . Status code: 4098. Description: Not found. Error code: 0x86D80018

This error may occur during you try to add the second node to the cluster, please ensure your SQL Servers are running successfully in each node before you check out my suggestions:

• If you don’t have Internet on servers and can’t update them, please start SQL Server installation on the node with the lower build number.
• Update your servers and make sure that they all have the same build number. Then, run cluster validation report, it should be “green”. Re-run cluster setup wizard on the second node.

You can follow the steps in this official document to add new node and ensure you've checked out the prerequisite:

You must be a local administrator with permission to log in as a service on all nodes of the underlying Windows Server failover cluster (WSFC). For local installations, you must run Setup as an administrator. If you install SQL Server from a remote share, you must use a domain account that has read and execute permissions on the remote share. To add a node to an existing SQL Server FCI, you must run SQL Server Setup on the node that is to be added to the SQL Server failover cluster instance. Do not run Setup on the active node.

In addition, here is a known thread like yours, Li Hong provided some steps to troubleshoot the issue, hope this can help you well!

Feel free to share your issues here if you have any concerns!

Best regards,

Lucy Chen

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.

https://docs.microsoft.com/en-us/answers/support/email-notifications