"Benzine" <Benzine@discussions.microsoft.com> wrote in message
news:916AA9AD-1EDB-4C5A-8D84-AC89E8D3E781@microsoft.com...
>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" wrote:

> Can you make the subscriberlogin account part of the dbo_role on the
> subscriber? I think this should solve your problem.
>
> --
> 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
>
>
>
> "Benzine" <Benzine@discussions.microsoft.com> wrote in message
> news:916AA9AD-1EDB-4C5A-8D84-AC89E8D3E781@microsoft.com...
> >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.
> >
>
>