Hi @Marco Bakker,
Can you ping between nodes? Make sure that the fourth replica can communicate with the other three replicas and that all necessary ports are open.
Did you join the Windows cluster for this node? You can check the specifics via Failover Configuration Manager. The cluster log in there will record some error messages.
In the case of four nodes, you also need to configure the Quorum mechanism.
Windows Server Failover Clustering (WSFC) uses a quorum-based approach to monitoring overall cluster health and maximize node-level fault tolerance. A quorum node set is a majority of the voting nodes and witnesses in the WSFC cluster. The overall health and status of a WSFC cluster is determined by a periodic quorum vote. The four nodes will appear 2-to-2.
Please refer to this article:
In addition, here is a MS document:
Best regards,
Seeya
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".
Hi @Marco Bakker,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Hi Ben,
It is W2012R2 standard and SQL2016 enterprise edition. And the new to be added replica's are W2016 datacenter and SQL 2019 enterprise.
Hope this helps.
kr
Marco