Renaming an SQL Server

Have you ever renamed an SQL server via the built in Windows GUI and then afterwards found that the SQL server hostname hasn’t changed when running “select @@servername

Search no more, there is an easy fix to this problem!

sp_dropserver ;
GO
sp_addserver , local;
GO

Then reboot the SQL Server service

If you found this article helpful, would you consider buying me a Coffee?