0
When I manually tried to make a failover I got the following errors:
"SQL always on Cluster IP address resource listener cannot be brought online because a duplicate IP address was detected on the network. Please ensure all IP addresses are unique. event 1049"
As a result, all the resources of the Cluster\Listener\witness were in a failure state and could not be moved back to online state.
When I aborted the failover attempts, everything returned to normal.
version:
SQL SERVER 2016 SP2 Enterprise edition
2 nodes (Primary and secondary)
Erez Hasman
Posted 2019-06-06T11:16:00.373
Reputation: 1