Post reply

Renaming a SQL 7 HW Server

  • May 30, 2006 at 7:45 am

    #113819

    Hi we are in the process of formulating a plan of putting in some new replacement servers with New server names. 

    We have mostly SQL 2k and the process for this would seem to be fairly straight forward

    • Install SQL 2k on new box with identical directory structures as old box 
    • copy old Databases including system databases to new server
    • Start SQL Server
    • issue sp_dropserver oldservername/instance 
    • issue sp_addserver newservername/instance

     

    However we also have a SQL Server 7 Server, and I believe a little more is involved.  After a bit of a search on here and Google, it would seem that after I move all of the databases across to the new server, I would need to run the SQL Server set-up disk again to rename all of the old server name references.

    My question  is what part of the SQL Server 7 set-up do I need to re-run to get the server name change recognized by SQL Server.  Is there a rebuild function on the set-up

    Cheers

     

     

     

     

  • May 30, 2006 at 11:33 am

    #640744

    Is the old server getting offline?

  • May 30, 2006 at 2:45 pm

    #640781

    This is what I have in my records from a while ago. I don't remember the source. I do remember that what I had to do is to follow the recommendation below, insert the setup disk and answer Yes when prompted to upgrade. In a very short time it completed the "upgrade" from name to a new name and I did not have problems. I do understand it does not answer your question what utility to run, but I don't remember doing that, I just inserted the setup SW and answered Yes to the question about the upgrade. I don't remember if it asked me about the registration key, maybe it did.

    Renaming a Server (SQL7.0)

     

    Note If you change the computer name of the server, you cannot start Microsoft® SQL Server™ until you run SQL Server Setup. You will be prompted to upgrade, and the necessary SQL Server options will be reset with the new computer name. After you’ve upgraded, you can exit Setup. Your databases will not be affected by this procedure.

     

    Regards,Yelena Varsha

  • May 31, 2006 at 2:34 am

    #640848

    Hi Yelena,

    Thanks for that, that seems to be exactly what I am after .  

    I had found seen some limited notes on renaming a SQL 7 Server and it just said that you had to run the SQL setup disk again.  I had mistakenly assumed that it was a utility on the Set-up.

    mngong,

    We will be keeping the old server operational until the data is moved to the new server (which will be done out of business hours).  We will be keeping the old server until we are happy with the new one as our standby backout plan

    Cheers

    Simon

     

     

     

  • May 31, 2006 at 10:12 am

    #640985

    If you are running SQL Server 7.0, after renaming the SQL Server machine, the SQL Server service will fail to start, with an error message "Your installation was corrupted or had been tampered with. To get around this problem, you have to rerun the SQL Server setup. Setup will prompt you to upgrade. After doing so, the necessary SQL Server registry entries will be reset with the new computer name. Now you will be able to start SQL Server. After restarting, use Query Analyzer to  run the following commands:

    EXEC sp_dropserver 'Your_OLD_Computer_Name'

    GO

    EXEC sp_addserver 'Your_NEW_Computer_Name', 'local'

    GO

    Restart your SQL Server service. Connect using Query Analyzer and run the following command (It should output the new server name):

    SELECT @@SERVERNAME

    GO

    ------------
    Prakash Sawant

    http://psawant.blogspot.com

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

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