I have a database in a high availability group with two nodes and one listener.
Several times a week, I have a problem with switchovers. The message I get is:
Stopped listening on virtual network name ''. No user action is required.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
When your cluster tries multiple times to attempt a failover and it maxes out on the failover threshold value, an error that you described occurs. Basically it gives up and goes into a failed/offline state and stops listening on Virtual Network Name. To find the RCA of your issue, you need to identify the errors that occurred prior to this error. Let's us know what you see and then we can further dig into issue.