Change SQL Server Name

Rename SQL Server

--Show Current Server Name
SELECT @@SERVERNAME AS 'Server Name';  

--Change Name
EXEC sp_dropserver '<old_name>';  
GO  
EXEC sp_addserver '<new_name>', local;  
GO

--Restart Instance