Post reply

Problem in modifying DNS alias on SQL 2000 cluster

  • June 17, 2009 at 9:29 pm

    #73222

    Hi,

    we're moving our sql2000 db server to a new server. The source server has SQL2000 active/active cluster configured with 3 named instances running. we shutdown ClusterB and move all the groups to cluster A. Now, after I restored the dbs to the new server, we modified the alias on the DNS server (changed the IP address) to redirect to the new server. We're thinking that by doing this, we don't have to change the odbc connections of every remote clients out there. All remote clients are configured to point to the DNS alias instance name. however, this method doesn't work as the DNS entry kept reverting back to the old server IP address. Anyone had any experience on this or any help is appreciated.

    Thanks,

    Desperate SQL

  • June 19, 2009 at 3:17 am

    #1012237

    Did you get the change made in the master DNS server or a slave?

    If your DNS environment is integrated with AD (which is normal) then the change needs to be made on the domain controller that is the primary reference for your leg of the DNS tree. If no delegation of authority is done in your AD setup, then the primary reference is always the master domain controller.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

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

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