Home Forums SQL Server 2005 Administering renaming a server RE: renaming a server
duvvit
SSC Enthusiast
Points: 150
More actions
February 11, 2010 at 3:44 am
#1117481
THIS, worked for me:
select @@servername
sp_helpserver
sp_helpremotelogin 'xxxx'
--sp_dropremotelogin 'xxxx','DOMAIN\account'
--sp_dropremotelogin 'xxxx'
--sp_dropserver 'xxxx'
sp_dropserver 'xxxx', 'droplogins'
sp_addserver 'xxxx-new', local