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.