Share via

Update CNAME record for Always on configuration on SQL Server Standard Edition

mo boy 396 Reputation points
2022-08-18T07:22:55.793+00:00

Dear Experts,

This is a 2 node cluster. Both SQL Server 2019 Standard.

There are around 80 databases. All of them have Basic Availability group set up.

But none of them have listeners. We don't want to create so many listeners now and can't upgrade to Enterprise.

Please clarify few questions,

  • How can we update Cname record to get this to work
  • What are the implications of having 80 separate listeners

Thanks,

SQL Server | Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,401 Reputation points Microsoft External Staff
    2022-08-19T06:52:12.923+00:00

    Hi @mo boy ,

    > How can we update Cname record to get this to work

    Did you mean that you want to create a CNAME (alias) pointing to primary SQL replica? This Alias will instead of 80 listeners? If one AG failover, it seems this alias will not work for this AG. A listener is already a virtual name always pointing to the primary replica of AlwaysOn . Why would you want to create a CNAME on top of it? If I misunderstood your requirement, please let me know.

    > What are the implications of having 80 separate listeners

    As far as I know, the answer is NO.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.