After renaming the server, run the following:
--After renaming the physical server , run the following: ----------------------------------------------------------------------------------------------------- master.dbo.master.dbo.sp_dropserver 'oldServerName' GO master.dbo.sp_addserver 'newServerName', 'local' GO --Restart the SQL instance at this point. ----------------------------------------------------------------------------------------------------- --After restarting, run the following to confirm that the previous was successful. Is should return the new server name. ----------------------------------------------------------------------------------------------------- SELECT @@SERVERNAME AS 'Server Name' -----------------------------------------------------------------------------------------------------