How to rename a SQL 7.0 Server


To create a test server of an old legacy Windows 2000 Server that was hosting SQL Server 7 we took a virtual copy and renamed the server within Windows.

After a reboot and you try to start the SQL Server service you receive the daunting error:

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

The error is generated after a change to the Windows server name and as SQL Server detects a different name which it uses internally it throws up the error.

To resolve is a 2 step process.

1. Run SQL Server 7.0 setup from the original CD and select Install SQL Server 7.0 Components. Select the relevant Database Server Edition for example Database Server – Standard Edition then select your install method for example Local Install.

It asks if you wish to Upgrade. Apparently selecting this option merely updates the registry settings with the new server name

When it has finished restart the server.

2. Once the server has restarted open Query Analyzer and run the following query substituting the server names and including the quotes:

sp_dropserver ’old server name’

sp_addserver ’new server name’, ’local’

Open Enterprise Manager and remove the old server registration. Add a new server registration for the new server name.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s