.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Error for logread.exe and distrib.exe when I setup Peer-to-peer replication

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :


I am in engineering design field and fairly new to SQL server. One of our applications use SQL server 2005.

I have setup Peer-to-peer replication. As soon as replication setup is completed, I start getting error for logread.exe and distrib.exe on satellite server (this is in India).

I get below error (same for logread.exe):

Distrib.exe Application Error , Application failed to initialize properly(0xx0000142)click ok to terminate the application

I have tried hard to resolve this issue but no success. I have deleted the replication many times and tried recreating but still no success.

user id I have used for Snapshot agent, log read agent has enough DBO permissions on both servers.

Please if someone can help me resolving this issue.

Best Regards,

Kshitij Nanavaty

View Complete Post

More Related Resource Links

peer to peer replication, drop and add article of same name

We have peer-to-peer replication set up on our system (2005 EE). I would like to change the metadata of one of the tables (many of the tables actually, but right now I'm just trying to test out the process with just one table). As this is a high-availability system, I would like to stop the replication, make the changes on one node, verify that the changes are working, make the same changes on the other node, then re-enable replication. The ddl changes to the table are extensive enough that I have to clear them before executing. So I will handle re-populating the tables in a later step. Right now I'm just testing the process of stopping, doing ddl, then restarting. I am trying to implement this using scripts so as to minimize my clicking (and thus potential for mistakes) when doing it for real. I find that if I do the following process using the SSMS interface it goes smoothly with no errors (note that each step is conducted on both nodes unless specified): stop sync agents manually remove article: tblName1 with 'publications properties window' close 'publications properties window' make ddl changes to tblName1 (change column names, add columns etc. to a particular table) manually add article: tblName1 with 'publications properties window' re-enable agents But if I try the following, I get 'Peer-To-Peer topologies require identical articles in publications at all n

Is peer-2peer replication going to be part of Standard Edition?

We currently use merge replication and have had numerous issues with it.  Primarily that there is a single point of failure. We are looking at moving to peer-2-peer transactional replication but we are currently running standard edition and have no plans/budget to upgrade. Will peer-2-peer be available in standard edition in the near future?   Thanks, Paul

replication peer-to-peer w/o init, source changed before replication


We setup a replciation peer-to-peer source / destination has sperated publisher and distributor each. 

The subscription set without initialize.  But the source db got changed before replication indeed.  Then we find there was something sent by destination distributor which hold all the process for a long time.

The question is: why is it not sent from source to destination? Does the destination try to question the change but very slow, and get the change back very quickly?

Index maintenance on peer 2 peer replication


Under normal non-replicated circumstances, we add maintenance plans, scheduled weekly, to rebuild indexs in our SQLServer databases. We have implemented peer to peer replication to run a software project from a major application vendor and the vendor is stating that "index maintenance plans are unsupported" in this implementation. In order to rebuild indexes, we therefore would need to break replication, rebuild indexes, then re-establish replication.

In short, can index maintenance plans be run against all nodes in a peer-to-peer replication scenario without effecting replication?




Replication Setup Error



I'm setting up replicaiton between two MS SQL 2008 servers and I'm having issues getting the snapshop at the publisher to work.  I get the following message:

 The replication agent has not logged a progress message in 10 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Distributor are still active.

I have created a windows account on the network, provided that account with admin rights and I have changed agent to use this account to run.  Repldata has been shared and I provied that created account with full rights to that folder.  That account also has the db_owner rights on the DB that I am trying to replicate. 

Am I missing a step? What might be the issue here?



SQL 2008:Peer 2 Peer Replication: Update-Update Conflict on the same node


My environment is comprising of 2 SQL servers setup with P2P replication in SQL 2008, 2 Web servers connect to only one SQL server at a time and make changes to the published tables and 2 Application servers which connects to both the SQL servers all the time but they only read data.

We chose P2P since my app servers are in different locations which read data from both the SQL servers and we use it as HA solution.

Since we are changing data at only one SQL server, thought we should never get update-update conflicts but we are now on the same node.

A conflict of type 'Update-Update' was detected at peer 3 between peer 1 (incoming), transaction id 0x0000000000725ca2 and peer 1 (on disk), transaction id 0x00000000007259e9 (Source: MSSQLServer, Error number: 22815)

We are making changes only at Server A and Server B is my backup server.

I made a varchar field updated in 1 row on a table in server A then it gets replicated to Server B
then I made the same field updated for 160 rows on the same table in Server A then it gets replicated to Server B
then I reverted back the change made to the field on all 160 rows on the same table in Server A then my replication failing with Update-Update conflict.

I'm not sure whats causing this because I'm not making any change

Sql 2008 peer-to-peer replication and jdbc driver


Hi, sorry but i'm a sql dummy...:-)

I setup a sql 2008 p2p replication for a database.

Can i specify, on a jbdc connection string, the path of the 2 sql server for automatic failover?

I try failoverPartner variable, but this is only for database mirroring.....

Can u help me?

Thanks in advance


error occurred while I tried to setup transaction replication with updateable subscription

   when I tried to setup transactional replication with updatable subscriptions between two nodes, an error occurred.

The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "REPL1 " was unable to begin a distributed transaction. Changed database context to 'database1'.

OLE DB provider "SQLNCLI" for linked server "REPL1" returned message "No transaction is active.". (.Net SqlClient Data Provider)
 May I know whether in order to setup transactional replication, do I need to run replication agents under domain users or local users?

thank you

SQL Server Peer to Peer Replication and High Availability

I am looking at peer to peer replication to replace our current mirroring solution.  ADO.Net has the partner server which works great when detecting the failover to the mirror.  Will that workin a peer to peer configuration as well?

How to I drop a node in peer to peer replication?


I have P2P replication going from say DB1 to DB2 and we are now just bought a couple more servers say DB3 and DB4. Our goal is to retire DB1 and add one more node in our replication. So we are thinking of setting up our replication so that it'll do following

first -  DB1 to DB2 to DB3 to DB4

Second - when all replications are setup. We'll drop DB1.

The plan seems techincally possible, but I don't know it'll works.

Have anyone done anything like this before? if yes, could you share with us if there is any problem you have encountered.

Thanks a lot in advance.



Philly Database developer

Peer Fun: A Peer-To-Peer Work Processing App With WCF


We demonstrate creating a peer-to-peer processing platform where multiple players function together for a common purpose: getting your work done.

Matt Neely

MSDN Magazine June 2009

WCF P2P: How To Design State Sharing in a Peer Network


Learn how you can peer-enable business applications by allowing them to share state in a serverless peer network.

Kevin Hoffman

MSDN Magazine July 2008

Peer To Peer: Harness The Power Of P2P Communication In Windows Vista And WCF


P2P applications face a number of barriers preventing their wide adoption as a productivity solution. Fortunately Windows Vista improves the situation, as you'll learn here.

Justin Smith

MSDN Magazine October 2006

.NET P2P: Writing Peer-to-Peer Networked Apps with the Microsoft .NET Framework


Peer-to-peer applications such as Napster, Gnutella, and Scour that communicate as peers sharing and receiving information are becoming commonplace as a means for users connected on large networks to take advantage of the vast resources available to them. The Microsoft .NET Framework provides a rich platform for building P2P apps. This article explains the concepts that make up peer-to-peer applications. The peer-to-peer application model, discovering other peers, and querying peers for information are discussed. The article goes on to cover the System.Net namespace for the use of Internet protocols, the System.Web.Services namespace for exposing Web Services, and firewall and port issues. Finally, the role of the .NET Framework in simplifying the design of powerful peer-to-peer applications is outlined.

Lance Olson

MSDN Magazine February 2001

How to overcome .net download error during setup

Hello All,We have a .NET 3.5 SP1 WPF application that we deploy to our costumers using a setup and deployment project in Visual Studio.In order to make things easier to our costumers, we provide in a specifc URL path for the setup.exe file and the .msi file.As the .net 3.5 is a prerequisite for the app to run, the setup.exe properly detects when it is missing form the costumer PC and ask to start the instalation.This works fine for most of our costumer, but, for some of them, the download fails with the following message:An error occurred downloading the following resource:http://go.microsoft.com/fwlink/?LinkId=37283 (something similar to this path).I suspect that some costumer have firewalls or anti-virus programs that block file download trought a non autorized program.Most of our costumer have dificulties to install the application and they actually don´t know anything about internet security or deployment process, so they expect the installtion to be an easy process.I would like top hear from you could be really causing this and how do you suggest to workaround this issue, so the user don't have to bother about prerequisites instalation.Kindly Regards,Igor.Project Manager at INOVATIVA Tecnologia www.inovativatec.com

Net Framework 1.0 Error 1904 during setup mscoree.dll H-result 2146232576

I cleaned off all my .Net framework files with the .Net framework cleaner. I then started at 3.5, installed it, went well, installed 3.0, went well, installed 2.0, went well, installed 1.1, went well, then, tried to install 1.0 redistribution package for my windows xp home and it stopped at almost the very end saying ERROR installing 1.0 ERROR 1904 system32\mscoree.dll failed to register. H-result 2146232576. I tried renaming it and installing the 1.0 again but still get the same error. i tried using the IGNORE option, it said it installed but i know the mscoree.dll isn't working. i used the installer cleanup tool also to no avail. i deleted the URTTemp folder and tried a reinstall. This didn't work either. Anyone know what I might can do to get this corrected? I have not done anything myself in the registry. I have used RegCure and registry mechanic but Net Framework 1.0 still gave the error when I tried to install. Any help appreciated. I did read something about 1.1, 2.0,3.0 or 3.5 might have a newer mscoree.dll file and that night be why I can't register the one I have. I need the 1.0 version 3705 though as one of my programs uses it. Also, i am now not able to put any of the updates on my computer. it downloads them but they fail to install. Example, net framework 2.o service pack 2, net framework 3.5 service pack 1, and net framework 3.5 family update. Thanks....

Error in Replication: connection was chosen as the victim in a deadlock

I'm using a merge replication with SQL 2008 at server and SQL Express 2008 on subscribers. We are using around 100 subscribers. I'm getting the following error once two subscribers replicate at the same time. The final number of transaction uploaded to the server is always arong 100 and a similar number in the downloads, so the amount of transaction is not an issue. I'he been playing with the merge profile with no luck. The merge process could not replicate one or more INSERT statements to the 'Publisher'. A stored procedure failed to execute. Troubleshoot by using SQL Profiler. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200990) Get help: http://help/MSSQL_REPL-2147200990 A query executing on Publisher 'xxxxx' failed because the connection was chosen as the victim in a deadlock. Please rerun the merge process if you still see this error after internal retries by the merge process. (Source: MSSQLServer, Error number: 1205) Get help: http://help/1205 Any idea? This is getting to a critical point where transactions are not being uploaded to the server.  Additonally, there are a lot of blocks between the subscribers, and they are mainly associated with table MSmerge_partition_groups  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend