Subscriber changing computer name after replicatio

• alspaugh

  Grasshopper

  Points: 13

  More actions

  June 16, 2003 at 3:20 pm

  #81836

  Hello,

  I have an application that uses merge replication we have a SQL 200 server

  and the client use MSDE 2.0

  I have a subscriber that changed there computer name and it broke the

  application

  After that I created a script that changed the MSDE name on there computer

  using the stored procedures sp_dropserver and sp_addserver and the

  application replicated once.

  The next time they replicated they got the error

  "The merge process could not initialize the subscription."

  "{?=call sp_MSaddanonymousrepica (?,?,?,?,?,?)}"

  "The subscription already exists."

  I did some testing it seems to change the name fine and sync but after you

  reboot you get the error - I assume when you stop and start sql services

  There must be a table on our server that references the subscription name

  that needs changed from the old computer name to the new but I cant find it.

  Any help anyone could give me would be appreciated

  Thanks,

  Jason Alspaugh

  jalspaugh@modernfold.com

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  June 17, 2003 at 6:33 am

  #461709

  It would be better to unsubscribe, drop and recreate the publication in the subscriber, instead modifying the sys tables by hand.