Good morning,
I’m setting up a SQL Server cluster running on Rocky Linux. The installation is going well, and the configuration seems to be fine since the cluster is up and running and the availability groups are working correctly. The problem comes when I’m trying to do a failover. When I put one of the two nodes in standby mode, the resources stop responding and I get the following error message:
Failed Resource Actions:
- ag_cluster promote on ClusterSQLQA02 returned ‘error’ (2024/08/26 08:43:38 Not enough replicas are online to safely promote this replica: need 2 but have 1) at Mon Aug 26 08:43:32 2024 after 5.483s
I’ve checked some forums without success, trying configurations like the following: required_synchronized_secondaries_to_commit=0 no-quorum-policy=ignore stonith-enabled=false
While browsing online, I’ve seen that the configuration can be done with just two nodes, but I haven’t been able to get it to work.
I hope someone can help me with some ideas, or if anyone has had a similar issue and managed to solve it, I would really appreciate it if you could share the solution you found.
Thanks in advance for your help, cheers!