Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002

    Unanswered: Subscriber changing computer name after replication has been setup


    I have an application that uses merge replication we have a SQL 2000 server
    and the client use MSDE 2.0

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

    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


    Jason Alspaugh

  2. #2
    Join Date
    Aug 2002
    Its better to re-define replication process again, once you restarted the SQL server.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts