473,511 Members | 15,131 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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.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?ProdN...6&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

May 11 '06 #1
0 1823

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2961
by: Sangbae | last post by:
I cannot create table using adodbapi. I have no problem with SELECT etc. But I can create table using win32com.client directly. I don't know why. Could you give some advice, please? This...
1
4565
by: Darren | last post by:
Hello, I have some 'CREATE TRIGGER' definitions that work when cut/pasted into SQL*Plus worksheet and execute separately but fail with a 'trigger created with compilation errors' when executed...
0
2685
by: Jerry Asher | last post by:
I have a table sort of like: create table firehydrants ( center point, hydrant integer primary key, ); How do I create firehyrants2 from firehydrants where the points are broken out into...
0
4358
by: G. Brannon Smith | last post by:
I've been hitting the DB books lately and I was wondering if anyone knows where features like "CREATE ASSERTION" and sub-selects in CHECK constraints stand in the TODO queue for production PgSQL....
1
7353
by: A.M. de Jong | last post by:
Can I dynamically (from a stored procedure) generate a create table script of all tables in a given database (with defaults etc) a create view script of all views a create function script of all...
0
800
by: Patrick | last post by:
I have 2 developper machine running visual studio 2003 and Windows 2000. On the first machine (Machine A) I may create a new asp project without problem. On the second (Machine B) I cannot create...
0
1402
by: Ingo Kollesch | last post by:
Hi, how can I create groups? When I will create Groups, i select User and Groups Objects in the control center, than I select "DB Groups" and select "Add". In the Form "Add Groups", I open the...
8
13941
by: Horst Walter | last post by:
I create an Excel worksheet in C# (should be similar in VB) Connection String: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";" + "Extended Properties=Excel 8.0;"; Create...
37
3245
by: Steven Bethard | last post by:
The PEP below should be mostly self explanatory. I'll try to keep the most updated versions available at: http://ucsu.colorado.edu/~bethard/py/pep_create_statement.txt...
12
1268
by: Xie Yubo | last post by:
Hello every, I have a question, could you help me? How do I enforce the user create a object via operator new only? For example, there is a class C: class C { ..... }
0
7237
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7349
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7417
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7074
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
1
5063
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3219
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3210
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1572
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
445
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.