By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,265 Members | 1,343 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,265 IT Pros & Developers. It's quick & easy.

Create Peer-to-Peer Topology Error Message

P: n/a
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'.


An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)


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:

For help, click:



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.

May 11 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.