USE master

sp_dropserver '<original computer name>';  
GO  
sp_addserver '<new computer name>', local;  
GO
ALTER LOGIN "<original computer name>\<windows login account>"
WITH NAME="<new computer name>\<windows login account>"