Post reply

MSSQL 2014 : MultiSubnet AOG, ping to the listener Name, is pinging on the DR site.

  • December 6, 2017 at 12:34 am

    #326734

    Hello Follow DBA's,

    We are currently building a DR/HA solution between 2 data-centers (Tokyo-Osaka), 
    The listener has 2 IP's (one by Data-center), one Online, one OffLine.

    My issue is when i ping the Listener name, it tries to ping the OffLine IP.

    Is it a normal behavior that is only fixed at the application level in the config string (MultiSubnetFailover=True ) ? or a different trick exist ?

    We wanted to use a CNAME targeting the Listener NAME, but it doesn't like it much 🙂

    Thanks for your time.

  • December 6, 2017 at 5:21 am

    #1970897

    For the listener networkname cluster resource you need to set the RegisterAllProvidersIP cluster parameter to 0.
    The default annoyingly is to set all providers ( value=1 ), however, you can change this via powershell using the following

    Get-ClusterResource <AG Listener Resource Name> | Set-ClusterParameter -Name RegisterAllProvidersIP -Value 0

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • December 6, 2017 at 9:17 am

    #1970955

    make sure you use FQDN for listener e.g. listener_name.domain.com when use ping or for connection.

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

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