I was looking for a solution in which my application, one which I can configure only one Listener param, if we can address multiple Availability Groups or not.
I have heard of using multiple listeners for one or multiple AGs, but is it possible to use a single listener and address multiple AGs?
Sql-server – MSSQL Single Listener for Multiple AGs
availability-groupssql server
Related Question
- Sql-server – SQL Server 2014 Always On .. can I have replication without a listener
- SQL Server Availability Group Listener – Setup and Configuration
- SQL Availability Groups – Using Cluster Name Instead of Listener Name
- SQL Server – Assigning Port to Listener in AlwaysOn
- Sql-server – Read Scale Availability Groups and Listener
- Sql-server – Multiple AGs on same Windows Failover cluster the Listeners don’t work properly
- sql-server,availability-groups – Selecting Ports for Availability Groups Listener and SQL Instances
Best Answer
A listener is specific to Instance of AG so you cannot connect to multiple AG's using one listener. If you have multiple instances you have to use multiple AG's.
How do you think a single listener will manager multiple AG's now how will it know which AG to connect ?