Pointing servername\instancename at an AG listener

  • Howdy all

    I have a question about whether something is possible. I've started working at an organisation that has a sql 2005 cluster with a named instances on it, lets call it Instance1. What they done is to create a dns alias for servername that is the same as the instance name, so when you connect to the sql server you connect "Instance1\Instance1".

    We want to move to SQL 2014 cluster with AlwaysOn Availability Groups doing the HA/DR, the question is if I create a listener name called "Listener1" is there a way to using DNS or anything else to point "Instance1\Instance1" to "Listener1"

    Any advice will be much appreciated 😀

  • romanoplescia (7/3/2015)


    Howdy all

    I have a question about whether something is possible. I've started working at an organisation that has a sql 2005 cluster with a named instances on it, lets call it Instance1. What they done is to create a dns alias for servername that is the same as the instance name, so when you connect to the sql server you connect "Instance1\Instance1".

    We want to move to SQL 2014 cluster with AlwaysOn Availability Groups doing the HA/DR, the question is if I create a listener name called "Listener1" is there a way to using DNS or anything else to point "Instance1\Instance1" to "Listener1"

    Any advice will be much appreciated 😀

    The listener points directly to the current primary within the AO group, if read only routing is configured correctly and any secondarys are set to readonly it will also re direct read intent traffic, no need for DNS aliasing.

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

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

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

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