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

    Unanswered: Subscriber changing computer name after replication has been setup

    Hello,

    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
    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

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Its better to re-define replication process again, once you restarted the SQL server.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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