rename a SQL Server host

When you rename a machine with SQL Server running, you also need to rename it in SQL:

select @@servername

sp_dropserver 'old name'
GO
sp_addserver 'new name', local
GO