Results 1 to 4 of 4

Thread: Rename A Server

  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: Rename A Server

    We want to migrate a SQL 7 to SQL2000 (there will be a new box) and then rename the old SQL 7 box and keep it on the network.

    Seems like I remember there is a problem when your rename a SQL server.

    Anyone have experience with this?

    Thanks

    Chuck

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    ...And this is what M$ says about this process:

    Q. Can I rename a server after installing SQL Server 2000?

    A: Yes, you can rename a server after the installation of SQL Server 2000. When the SQL Server service starts for the first time after the name change, it automatically recognizes the change and resets the computer name. You do not need to run setup again to reset this value. However, you must perform several additional configuration steps. To correct the sysservers system table, you should manually run the following procedures.

    For a default instance: sp_dropserver <old_servername>
    go
    sp_addserver <new_servername> , local
    go

    For a named instance:sp_dropserver <old_servername\instancename>
    go
    sp_addserver <new_servername\instancename> , local
    go

  4. #4
    Join Date
    Jan 2004
    Posts
    2
    Thanks.

    I'll try that. It is actually SQL 7. We are upgrading a SQL 7 server to SQL 2000. The SQL 2000 is a new box and we want to keep the SQL 7 server around on the lan for a while.

    Thanks again

    Chuck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •