Change SQL Instance name to reinstall CRM 2011

I was in middle of the installation and system was throwing exception that instance name must be same as of machine name. so I had to update the instance name of SQL server. following is a script I found online and it was really helpful.

USE master
GO

---- Fetch the SQL Server instance name - fetch the value of "name" from the output
--sp_helpserver
--GO

-- Drop the old server registration
sp_dropserver 'WIN2K8\SQL2K12','droplogins'
GO

-- Register the new server with the new name
sp_addserver 'CONTOSSSO\SQL2K12',local
GO

Source