Firewall access for Availability Group listeners

• webrunner

  SSC-Dedicated

  Points: 30571

  More actions

  December 4, 2020 at 3:26 pm

  #3816969

  Hello experts,

  I have a noob question as I never feel like I understand enough about networking.

  Suppose I have a client CLIENT01 that I want to allow to connect to listener MyAG01 (IP 2.2.2.2).

  Behind MyAG01 (IP 2.2.2.2) are three nodes:

  MyNode01 (IP 4.4.4.4)

  MyNode02 (IP 5.5.5.5)

  MyNode03(IP 6.6.6.6)

  I can't grant access myself but have to request it from another team. Which access do I need to request?

  1. Only access from CLIENT02 to MyAG01 (IP 2.2.2.2)
  2. Access from CLIENT01 to MyAG01 (IP 2.2.2.2) AND

  MyNode01 (IP 4.4.4.4)

  MyNode02 (IP 5.5.5.5)

  MyNode03(IP 6.6.6.6)

  I assume it is Option 1 (since MyAG01 (IP 2.2.2.2) is supposed to be the only point of access for clients) but want to make sure I request the access correctly.

  Thanks for any help!

  -- webrunner

  -------------------
  A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

• Site Owners

  SSC Guru

  Points: 80372

  More actions

  December 5, 2020 at 4:10 pm

  #3817310

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.