How to change the SQL Server name or instance

Here are commands that need to run to change SQL Server name or instance:

sp_dropserver 'old instance name'

sp_addserver 'new instance name', local

Then restart the SQL Server service.

After restarting run the following command

select @@servername