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>"
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>"
Leave a Reply