SQL Server 2019 AOAG - Listener issue

Chetan Jain 71 Reputation points
2023-12-06T06:50:27.9866667+00:00

Hello Team,

I am configuring SQL server 2019 enterprise edition with AOAG ( without Cluster).

SQL AOAG installation & configuration is done. Failover is happening properly.

When i am trying to configure SQL listener ( Object creation in AD and mapping in DNS with different IP is already done), it is creating the listener in SSMS but when i am trying to connect with deafult port, it is throwing an error.

Listener creation is done on the primary replica.

Kindly advise

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,297 questions
{count} vote

Accepted answer
  1. Erland Sommarskog 106.3K Reputation points MVP
    2023-12-10T11:23:04.45+00:00

    So listener and primary have different IP-addresses. Are you sure that this is supposed to work with a clusterless AG? Being mainly a developer, AGs is not really my expertise, but it is my impression that to have a listener with a clusterless AG, the listener needs to have the same IP-address as the primary. (Which means that after a failover, you need to drop and recreate the listener and update the DNS so that the listener points to the new primary.)

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful