SQL Server becomes corrupted when I change server name

Question

Hello,

I need to change system name where I have a SQL Server 7 running, but when I restart it I get this error:

"Your SQL Server installation is either corrupt or has been tampered with (unknown package id). Please rerun setup."

Should I perform any modification into SQL Server before to change system name?

FYI, OS is Windows 2000 SP4 and both (SQL Server and Windows) are in spanish.

Thanks in advance for your help.

Regards,

Carles

Answer 1

See http://support.microsoft.com/kb/195759/EN-US/

This is an exerpt: Please go to the original KB as it may have been updated.

---

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.