Groups | Blog | Home
all groups > sql server replication > june 2006 >

sql server replication : Server Renamed - Replication doesn't work


Jeff Ericson
6/14/2006 5:33:02 AM
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
Jeff Ericson
6/14/2006 8:19:02 AM
a reboot cleaned things up nicely.

[quoted text, click to view]
AddThis Social Bookmark Button