Once in a while it may become necessary to rename an instance of SQL Server. Because this isn't something that you do frequently it's easy to forget the commands. It's just a couple of commands (see below) followed by a restart of SQL Server.


exec master.dbo.sp_dropserver ''

exec master.dbo.sp_addserver '', 'local'


now, Restart SQL Server