Change the name and IP address of the server.

Reboot.

Click OK to close the SQL error message dialog box.

Run SQL Server 7.0 Setup from the CD for the the same version as the one currently on the computer (Standard or Enterprise).

• Choose Install SQL Components.

• Say Yes to upgrade.

Start/Programs/Microsoft SQL Server 7/Server Network Utility.

• On the general tab, remove Multiprotocol.

• On the general tab, add Multiprotocol (the new server name should pre-fill).

Start/Programs/Microsoft SQL Server 7/Query Analyzer.

• In the SQL Server textbox type a period or the new server name or (local).

• Check the Start SQL Server if stopped checkbox.

• Connect as sa with a blank password.

• Type select @@servername and press [F5]. This will return the old name of the server.

• Type sp_dropserver oldservername and press [F5].

• Type sp_addserver newservername,local and press [F5].

• Leave Query Analyzer open.

Stop and Restart the MSSQLServer service on the local machine (there are several ways to do this, you can use the Server Icon in the System Tray on the Taskbar).

Go back to Query Analyzer.

• Type select @@servername and press [F5]. This should return the new server name. If it does not, please repeat steps 6 and 7.

• File/Open. Browse for C:\Winnt\System32\instcat.sql and open it. Press [F5]. This script prepares the SQL Server for use with the GUI Tools that come with Visual Studio.

• Wait until the globe icon stops spinning and close Query Analyzer. Disregard any error messages.

Repeat step 7.