From:
Useful if you need to replace/upgrade a machine, and you also need to rename it.
Here's how to rename a server running SQL Server:
-
Rename the physical server by going to the "Identification" tab of the "Network" properties window (available from Control Panel) if you are running Windows NT 4.0. If you are running Windows 2000, go to the "Network Identification" tab of the "Computer" Properties windows (available from Control Panel).
-
Reboot the server.
-
Run the SQL Server setup program. At some point early in the installation you will be prompted to "Upgrade" SQL Server. Answer "yes" to this question. After a very short period of time, you will be prompted that the installation is complete.
-
Reboot the server.
-
Run this stored procedure: "sp_dropserver "
-
Run this stored procedure: "sp_addserver , local"