Post reply

Renaming SQL server 2000

  • October 25, 2004 at 6:36 am

    #86791

    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 2:10 am

    #527916

    You may want to check the Active Directory (if you are using it) as I have found that simply renaming a server isnt the end of the issue, as AD stores the server name in a multitude of places.

     

     -- Alex

     

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

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