Post reply

Renaming SQL server 2000

  • October 25, 2004 at 6:36 am

    #86825

    Hi,

    We renamed our NT4.0 (SP6a) server in which SQL Server 2000 is residing (sp3).

    The SQL Server recognized the new name immediately but it was recognizing the old name also.

    We ran the following command in the QA:

    sp_dropserver 'old server name'

    sp_addserver 'new server name', 'local'

    Still old and new registration to the server exists.

    select @@servername shows new servername. But I am able to register using both old and new names.

    Any suggetions on why this could happen?

    Thanks in advance.

     

     

  • October 26, 2004 at 3:54 am

    #527929

    Can you register the server with other clients?

     

  • October 26, 2004 at 9:44 am

    #528007

    Have you rebooted since then? The old one may still respond at a network layer.

  • October 26, 2004 at 10:33 am

    #528024

    The sad fact is you can change the IP address, but changing the server name always does this.  We have had this happen 3 times.  The only solution to get ride of the old name was to backup the DBs, uninstall SQL, clean the registry, and re-install SQL, then restore the DBs.

    If anyone has a real solution, I would be interested in it.

     

    Leo Kuneman

    AVR IT Program Manager

    FAA

     

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

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