sp_dropserver 'old_name'
go
sp_addserver 'new_name','local'
go

sp_dropserver 'Server Nameold_Instance_name'
go
sp_addserver 'ServerNameNew Instance Name','local'
go