Changing computer name after installing SQL Server

Not only had I managed to use a reserved site code name in my R2 build recently but I’d also named my server incorrectly – ‘ConfigMrg1’ yeah right!

So since I needed to reinstall R2 to I thought I would change the server name.

SQL didn’t need a re-install so I needed to run some commands in SQL to reflect the change in hostname.

To do this fire up SQL Server Management Studio and connect to the new hostname instance.

Enter the following in a query and execute:

EXEC sp_dropserver ‘old hostname’
GO

then run the following query:

EXEC sp_addserver ‘new hostname’, ‘local’
GO

Restart your SQL Server (MSSQLSERVER) service.

You can check that the process has worked by executing the following query:

SELECT @@SERVERNAME
GO

You can now safely re-start the SCCM install process