A 2005 server was renamed while replication was configured. I was able to
drop the publication, distributiondb, etc. using the sprocs but I can't
reconfigure due to SQL asking me to refer directly to the server name, not an
alias, IP, etc.. The server name it thinks I should use is the old server
name. sp_drop and add was run but I haven't stopped and started the service