Printable View
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
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
>
>
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
>>
>>
>
>
"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
>>>
>>>
>>
>>
>
