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

Found priceless insights in this blog? Support the author’s creativity – buy them a coffee!

Leave a Reply

Your email address will not be published. Required fields are marked *