Replication :How to re name a distributor?

• Hornblower

  Newbie

  Points: 2

  More actions

  November 2, 2008 at 8:46 pm

  #131963

  I have a server being configured as distributor, name "A", not add any publisher and subscriber. To make the server name more meaningful I changed its name and made it as database mirroring witness server.

  When I want to continue configure distribution on it, the server always ask me to connect to the old name("A"). I renamed the server back("A") and disabled distribution and want to start again from begining.

  After I renamed it to "B", replication is also inaccessible. It ask me to connect the old server "A".

  What can I do? Must I reinstall the server again?

• Stephen Knott

  SSC Eights!

  Points: 943

  More actions

  November 3, 2008 at 12:40 am

  #892889

  Hi,

  I have had this happen to me as well.

  I ended up using something like this :

  exec sp_dropserver 'A'

  exec sp_addserver @server='NewName', @local='local'

  Then check the return of @@SERVERNAME

  Should now return 'NewName'

  Hope this helps,

  Thanks,

  Steve

• Hornblower

  Newbie

  Points: 2

  More actions

  November 3, 2008 at 12:56 am

  #892890

  Steve

  Actually I thought there was not solution for it. I found that MSDN says replication does not support distributor server rename.

  Your solution is ABSOLUTELY helpful! However I cannot testit ,I have reinstalled all servers to setup again. I'm sorry for that.

  Many thanks!

  Horatio