Posts
1150
Comments
891
Trackbacks
1
How to rename a SQL Server

From: http://www.sql-server-performance.com/sql_server_maintenance.asp

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 <old server name>" 

  • Run this stored procedure: "sp_addserver <new server name>, local"

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

Post Comment

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