Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Replication / December 2006

Tip: Looking for answers? Try searching our database.

The Process Could Not Log Conflict Information

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Benzine - 22 Dec 2006 00:16 GMT
I recently setup merge replication and for each subscriber I add and try
and synchronize I get the following error message:

"The Process Could Not Log Conflict Information"

When I view the details of the error it states the following:

"The Process Could Not Log Conflict Information.
(Source: Merge Replication Provider (Agent); Error number: -2147200992)
---------------------------------------------------------------------------­------------------------------
SELECT permissions denied on object 'conflict_mydatabase_mytable',
database 'MyDatabase', Owner 'MyUser'.
(Source: SERVERNAME(Data Source); Error number: 229)
---------------------------------------------------------------------------­------------------------------
INSERT permissions denied on object 'conflict_mydatabase_mytable',
database 'MyDatabase', Owner 'MyUser'.
(Source: SERVERNAME(Data Source); Error number: 229)"

Judging from the Session Details it merges all data first but fails
right at the end with the above.

Can anyone help me with this??

PS. I had setup a test replication environment first and did not have
any problems, only once I put it into production I starting getting
these errors (My luck!)

PPS. I am running MS SQL 2000 Version 8.00.2039 and clients are using MSDE.
Hilary Cotter - 24 Dec 2006 02:54 GMT
Can you make the subscriberlogin account part of the dbo_role on the
subscriber? I think this should solve your problem.

Signature

Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

>I recently setup merge replication and for each subscriber I add and try
> and synchronize I get the following error message:
[quoted text clipped - 25 lines]
> PPS. I am running MS SQL 2000 Version 8.00.2039 and clients are using
> MSDE.
Benzine - 25 Dec 2006 04:58 GMT
Thank you for your reply, this has solved the problem.

Many thanks.

> Can you make the subscriberlogin account part of the dbo_role on the
> subscriber? I think this should solve your problem.
[quoted text clipped - 28 lines]
> > PPS. I am running MS SQL 2000 Version 8.00.2039 and clients are using
> > MSDE.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.