Post reply

SQL2019 AG setup on Azure with working Listener but not being shown

  • May 7, 2020 at 8:19 pm

    #3749775

    I setup a Windows 2019 cluster and SQL2019 AG on Azure for some proof of concept that I need for work. The failover and SQL connection to the Listener works, but does not show the Listener in Management studion neither via TSQL, so something is not right.

    I followed Microsoft documentation found here:

    https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-portal-sql-availability-group-tutorial#create-an-azure-load-balancer

    Which seems a bit odd, as Windows 2019 does not let me use a static IP for the cluster , not sure if that's related or not.

    Has someone faced this issue before, any ideas? I've attached a screenshot for reference.

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

  • May 8, 2020 at 9:10 pm

    #3750070

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

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

  • May 14, 2020 at 3:04 am

    #3751390

    If you look at the Cluster Resources does it have the IP address of the Azure Load Balancer?

    Does the AlwaysON Work? Failover and Failback?

    Did you run the PoweRShell Script with the correct parameters?

    Try to add the listener manually once the Load balancer and powershell scripts are correct.

    I had an issue like that before a long time ago but can't remember what I did to make it appear.

    However, even if it does not appear but the AlwaysOn works (Failover, failback, reboot one node, shutdown one node etc) then it might be a bug.

     

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

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