Changing Server Name


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Changing Server Name

  1. #1
    Levi Nkata Guest

    Changing Server Name

    Is there a way of renaming the SQL Server computer in the Network
    without having to re-install the database?

    I tried to rename my server and after restarting the computer, the SQL
    Server service couldn't start and prompted me to re-install.


    Levi Nkata



  2. #2
    James T. Stanley Guest

    Re: Changing Server Name

    Yes. I haven't done this since 6.5, so I don't have all the details. It'll
    require lots of updates to system tables and a few registry entries. It's a
    costly thing to do in terms of time, considering that you'll also need to
    reconfigure every client as well.

    James

    "Levi Nkata" <levi@zamnet.zm> wrote in message
    news:3AD1DD7F.84B8A891@zamnet.zm...
    > Is there a way of renaming the SQL Server computer in the Network
    > without having to re-install the database?
    >
    > I tried to rename my server and after restarting the computer, the SQL
    > Server service couldn't start and prompted me to re-install.
    >
    >
    > Levi Nkata
    >
    >




  3. #3
    Rand Boyd Guest

    Re: Changing Server Name


    Since you are using either SQL Server 7.0 or SQl Server 2000 that error message
    can be misleading. When either 7.0 or 2000 is installed the installation
    stores the encrypted computer name in a registy key. Therefore when you change
    the computer name it no longer matches the stored value. You then should
    get a message about the installation being corrupted or tampered with. all
    you need to do is run the setup program from the CD and choose Upgrade. There
    is a Microsoft Knowledge Base article that describes this. This is from Q195759.
    It describes the situation and resolution.

    Q. When I try to start SQL Server 7.0 on Windows NT or from a Windows 9x
    Command prompt, I receive the following error:
    Your SQL Server installation is either corrupt or had been tampered with
    (unknown package id) Please rerun setup.
    When I attempt to start SQL Server 7.0 on Windows 9x using the SQL Server
    Service Manager, nothing happens. What causes this and how can I resolve
    it?

    A. This error message appears if you have renamed the Windows computer on
    which you installed SQL Server 7.0. SQL Server 7.0 uses the Windows computer
    name internally; if you change the Windows computer name, SQL Server detects
    a different name and generates the error message.

    NOTE: Your data has not been corrupted or damaged in any way.

    To resolve this error and start SQL Server again, do either of the following:


    Run SQL Server 7.0 Setup from the original product CD. Doing so will not
    reinstall SQL Server or any components; however, it will update SQL Server
    7.0 internally to reflect the new Windows computer name. You also need to
    update SQL Server's internal servername by running the following two stored
    procedures:

    sp_dropserver <old_name>
    go
    sp_addserver <newname>, local
    go
    If SQL Server is configured to listen on either the Multiprotocol or NWLink
    IPX/SPX network libraries, you'll need to remove them, and then add them
    back using the SQL Server Network Utility.


    Rand Boyd









    "James T. Stanley" <jstanley@powerwayinc.com> wrote:
    >Yes. I haven't done this since 6.5, so I don't have all the details. It'll
    >require lots of updates to system tables and a few registry entries. It's

    a
    >costly thing to do in terms of time, considering that you'll also need to
    >reconfigure every client as well.
    >
    >James
    >
    >"Levi Nkata" <levi@zamnet.zm> wrote in message
    >news:3AD1DD7F.84B8A891@zamnet.zm...
    >> Is there a way of renaming the SQL Server computer in the Network
    >> without having to re-install the database?
    >>
    >> I tried to rename my server and after restarting the computer, the SQL
    >> Server service couldn't start and prompted me to re-install.
    >>
    >>
    >> Levi Nkata
    >>
    >>

    >
    >



  4. #4
    Nellie Guest

    Re: Changing Server Name


    "Rand Boyd" <randb@microsoft.com> wrote:
    >
    >Since you are using either SQL Server 7.0 or SQl Server 2000 that error

    message
    >can be misleading. When either 7.0 or 2000 is installed the installation
    >stores the encrypted computer name in a registy key. Therefore when you

    change
    >the computer name it no longer matches the stored value. You then should
    >get a message about the installation being corrupted or tampered with. all
    >you need to do is run the setup program from the CD and choose Upgrade.

    There
    >is a Microsoft Knowledge Base article that describes this. This is from

    Q195759.
    >It describes the situation and resolution.
    >
    >Q. When I try to start SQL Server 7.0 on Windows NT or from a Windows 9x
    >Command prompt, I receive the following error:
    >Your SQL Server installation is either corrupt or had been tampered with
    >(unknown package id) Please rerun setup.
    >When I attempt to start SQL Server 7.0 on Windows 9x using the SQL Server
    >Service Manager, nothing happens. What causes this and how can I resolve
    >it?
    >
    >A. This error message appears if you have renamed the Windows computer on
    >which you installed SQL Server 7.0. SQL Server 7.0 uses the Windows computer
    >name internally; if you change the Windows computer name, SQL Server detects
    >a different name and generates the error message.
    >
    >NOTE: Your data has not been corrupted or damaged in any way.
    >
    >To resolve this error and start SQL Server again, do either of the following:
    >
    >
    >Run SQL Server 7.0 Setup from the original product CD. Doing so will not
    >reinstall SQL Server or any components; however, it will update SQL Server
    >7.0 internally to reflect the new Windows computer name. You also need to
    >update SQL Server's internal servername by running the following two stored
    >procedures:
    >
    > sp_dropserver <old_name>
    > go
    > sp_addserver <newname>, local
    > go
    >If SQL Server is configured to listen on either the Multiprotocol or NWLink
    >IPX/SPX network libraries, you'll need to remove them, and then add them
    >back using the SQL Server Network Utility.
    >
    >
    >Rand Boyd
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >"James T. Stanley" <jstanley@powerwayinc.com> wrote:
    >>Yes. I haven't done this since 6.5, so I don't have all the details. It'll
    >>require lots of updates to system tables and a few registry entries. It's

    >a
    >>costly thing to do in terms of time, considering that you'll also need

    to
    >>reconfigure every client as well.
    >>
    >>James
    >>
    >>"Levi Nkata" <levi@zamnet.zm> wrote in message
    >>news:3AD1DD7F.84B8A891@zamnet.zm...
    >>> Is there a way of renaming the SQL Server computer in the Network
    >>> without having to re-install the database?
    >>>
    >>> I tried to rename my server and after restarting the computer, the SQL
    >>> Server service couldn't start and prompted me to re-install.
    >>>
    >>>
    >>> Levi Nkata
    >>>
    >>>

    >>
    >>

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center