SQL Server Error Msg 19477 – The availability group ‘%.*ls’ already has a listener with DNS name ‘%.*ls’.  Availability groups can have only one listener. Use the existing listener, or drop the existing listener and create a new one.

In this blog post, let’s learn about the error message “19477 – The availability group ‘%.*ls’ already has a listener with DNS name ‘%.*ls’.  Availability groups can have only one listener. Use the existing listener, or drop the existing listener and create a new one.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

19477 – The availability group ‘%.*ls’ already has a listener with DNS name ‘%.*ls’.  Availability groups can have only one listener. Use the existing listener, or drop the existing listener and create a new one.

Reason for the Error

To be update soon…

Solution

To be update soon…