Posts
463
Comments
322
Trackbacks
1
How to rename a SQL Server

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"

posted on Monday, July 18, 2005 10:28 AM
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 8 and 8 and type the answer here: