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

One comment

Leave a Reply to laptop service in chennai Cancel reply

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

WordPress.com Logo

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

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s