Monthly Archives: March 2014

How to Rename SQL Server

In case of server migrations or if you are in a situation to rename the physical server hosting SQL Server, Renaming SQL Server to host the new physical server name is pretty simple as done below

MSDN Reference for Add Server http://msdn.microsoft.com/en-us/library/ms174411.aspx

This procedure must be executed on all instances of the Database Engine hosted on the computer but the instance name of the Database Engine cannot be changed. On the SQL Server instance, run the following query:

sp_dropserver ‘<oldservername>’
go

sp_addserver ‘<newservername>’, local
go

Now restart the SQL Server related services. Then, the command below to verify if the new name has been updated.

select @@servername