Renaming a Stand Alone SQL 2005 Server

The other week I ran into an issue where I had to rename the server that a SQL 2005 instance was install on. It was a pretty simple process. First rename the server and reboot. As far as SQL goes all you have to do is update the sysservers table by running the stored procedures below.

For a renamed default instance, run the following procedures:

sp_dropserver
GO
sp_addserver , local
GO
For a renamed named instance, run the following procedures:
sp_dropserver
GO
sp_addserver , local
GO