Renaming SQL Server post-Sysprep

Sysprep is a very, very powerful tool. It's not a miracle worker, however, case in point, SQL Server. I always include the following SQL script in the image.

select @@servername
-- this script will rename a sql server
declare @new_name varchar(255)
set @new_name = '[new machine name]'
exec sp_dropserver @@servername
exec sp_addserver @new_name, 'local'
-- restart sql server

Then, I restart the SQL Server service (default name is MSSQLSERVER)

net stop mssqlserver
net start mssqlserver

UPDATE (4/21/2008)
If you've Sysprepp'd a machine with SQL Server Reporting Services installed, you'll need to reinstall it. SSRS holds onto either the original machine's SID or just the machine name. Either way, I haven't yet found out how to correct it.

Attachments:
SQL Rename.sql