473,803 Members | 4,458 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.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:
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 1842

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

Similar topics

1
2977
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 is my source. =====================================
1
4595
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 at the same time. Neither works at all under Solaris sqlplus. Does anyone see what the problem is? create or replace trigger aut_itri
0
2699
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 their x and y values?
0
4379
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. Are they even in development at all? Or have they been written off as too expensive? I did see somewhere that a developer version of the Pg server could be built with CREATE ASSERTION enabled but that was NOT recommended for production installs. ...
1
7371
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 functions a create index script of all indexes. (The result will be 4 scripts) Arno de Jong, The Netherlands.
0
809
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 a new project. Visual Studo create the project but not the initial files and freezes. But I may create a new project from Machine A using the web server of machine B. I have checked the access rights of both servers, the access rights on
0
1413
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 Combobox "Group" and I see the Combobox is empty. Why? I have create a user group in Win2k but the Combobox in the control center is empty. Ingo
8
13959
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 string: "CREATE TABLE S1 (Dt date, St char(40), Cr currency)" Works fine, but the worksheet is named _S1 (UNDERSCORE!) and not S1.
37
3314
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 http://ucsu.colorado.edu/~bethard/py/pep_create_statement.html PEP: XXX Title: The create statement
12
1295
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
9703
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9564
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10548
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10316
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10069
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6842
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5500
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
3798
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2970
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.