SEO

#1 (**permalink**) 03-01-2008, 11:53 AM

I recently setup merge replication and for each subscriber I add an 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!)

#2 (**permalink**) 03-01-2008, 11:53 AM

Benzine (bfausti@gmail.com) writes:
> I recently setup merge replication and for each subscriber I add an try
> and synchronize I get the following error message:

Not to belittle the knowledgeable people in this group, but your odds for a
good answer is probably better in microsoft.sqlserver.public.replication.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode