Post reply

Create DNS name and alias to use same old name to connect to new sql instance

  • August 8, 2014 at 12:50 pm

    #291874

    Here is my scenario:

    I have old server eg: A\B (named instance).

    I am migrating database to new server C\D (named instance) SQL Cluster.

    The problem is there are about 50 + users pointing to the old server(A\B).

    So, instead of manually changing connection on 50+ machines, server team suggested that they will create new DNS name and will alias to the old name to connect to C\D.

    Doing the above mentioned,we do not need to change anything in the connection even if it has datasource = A\B,

    as eventually it will be pointing to new server(C\D), is this true?

    Appreciate all the help.

  • August 13, 2014 at 9:42 am

    #1737660

    If you really don't want to change connection strings, then I think you'll need to make instance names the same, D=B. Otherwise should work, we've done it in past.

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

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