• 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