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’

then run the following query:

EXEC sp_addserver ‘new hostname’, ‘local’

Restart your SQL Server (MSSQLSERVER) service.

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


You can now safely re-start the SCCM install process

One comment

Leave a Reply to laptop service in chennai Cancel reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s