Multiple Avaliability Groups across Nodes and Listeners.

Question

Multiple Avaliability Groups across Nodes and Listeners.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

rvsc48 SSCertifiable Points: 7767 More actions · Answer 1

Every AG I set up had to have it's own listener. Each Listener has its own static IP and Port number defined when it is created. I don't see how else could an AG know which is the active node (or Primary) without one.

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 2

sysadmins can connect to any database/AG via any listener. Accounts with more restricted permissions cannot. Therefore I'd always set up one listener for each AG. If you don't, and the AGs fail over at different times, you can get some weird things happening.