|
|
Posted by EoRaptor013 on 10/02/88 11:47
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.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:
20026)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=20026&LinkId=20476
------------------------------
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
Navigation:
[Reply to this message]
|