Create Peer-to-Peer Topology Error Message

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • EoRaptor013

    Create Peer-to-Peer Topology Error Message

    I have been trying for several days to create a peer-to-peer
    replication among three servers. I first created the publication on
    Server A, enabled it for peer-to-peer to peer on the publication
    properties dialog then backed up the database and restored it to
    servers B and C. Once restored, I tried to Configure Peer-to-Peer
    Topology from the right click menu on the publication in SQL Management
    Studio (2005). When I click OK, the wizard gives expected warning
    messages that the log reader agent already exists. The wizard then
    quits with the following error:

    TITLE: Configure Peer-To-Peer Topology Wizard
    ------------------------------

    SQL Server could not create a subscription for Subscriber 'SERVERB'.

    ------------------------------
    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or
    batch. (Microsoft.SqlS erver.Connectio nInfo)

    ------------------------------

    The publication 'MyP2P20060510-02' does not exist.
    Could not update the distribution database subscription table. The
    subscription status could not be changed.
    The subscription could not be created.
    The subscription could not be found.
    Changed database context to 'MYDB'. (Microsoft SQL Server, Error:
    20026)

    For help, click:


    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    Since I can see the publication under the replication folder on each of
    the other two servers, I have no idea what the message really means. I
    (and the ID for the replication agent) have full access to the
    distribution database, the publication database, and everything else I
    can think of!
    Any help would be greatly appreciated.
    Randy

Working...