Connecting to listener lands on secondary node

• Divine Flame

  SSCoach

  Points: 15943

  More actions

  December 1, 2021 at 10:32 am

  #3959011

  Hi Folks,

  I have been observing a weird issue.

  We have one SQL 2017 AlwaysOn configured.

  When we try to connect via LISTENER, it connects us to Secondary node instead of Primary node.

  Any idea why this will happen and how to resolve it?

  Thanks.

  ---

  Sujeet Singh

• Johan Bijnens

  SSC Guru

  Points: 134737

  More actions

  December 1, 2021 at 1:41 pm

  #3959083

  did you specify the "ApplicationIntent=ReadOnly" parameter with your connection and is you secondary readable?

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me