Rename the Windows server.
Inside SQL run:
sp_dropserver serverb
sp_addserver servera, local
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com