AOAG Listener Error while creating the Listener from SSMS for SQL 2019

  • Hi,

    I am having error in creating AG Group Listener. We finally try to create one from Failover Cluster Manager by right click on AG role and added Listener from there.

    Listener IP comes online but  Listener name still shows offline state.

    Please if anyone having same error, how to fix this. I am lost.

    thanks

     

    • This topic was modified 1 year, 10 months ago by  Shashihemanth.
    • This topic was modified 1 year, 10 months ago by  Shashihemanth.
    Attachments:
    You must be logged in to view attached files.
  • Did you grant the cluster service account ?

    ref: "A Step by Step Guide to the Availability Group (AG) Listener"

    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

  • Hello Sir,

    Thank you so much for your reply. Cluster service account has full control and full permissions to the Listener. So I removed the AG Listener from the Failover cluster manager. Removed Listener computer name from AD and DNS and started all over again, with new Listener name.

    AS mentioned in the article attached, Created a new Listener in AD, added to DNS as well. Cluster name has full control on the Listener computer name.

    When I now try to add the listener from AG Group in SSMS. I am getting the following error. Attached. Please help if someone else is facing the same problem.

    Question: Does it cause any issues if the computer name for listener  is first added to DNS and then to AD? Do you think this might be the issue?

     

    Attachments:
    You must be logged in to view attached files.

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

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