Skip to content
Category: SQL Server

Conflict Resolutor Error

We found an error in Merge replication that im going to describe:

When a Subscriber SQL Server 2005 Express replicates against a Publisher SQL Server 2008 R2 with a publication that has filtered articles, the option use_partition_groups set to true and contains an article with a conflict resolutor different at default, the following error occurs:

The process could not initialize ‘Microsoft SQLServer Stored Procedure Resolver’. Verify that the component is registered correctly

We tried to upgrade SQL Server 2008 R2 to SP1 CU2, it is the last version come out, as well as this we has been proven to raise SQL Server 2005 Express to SP4 CU3 and error continues.The error doesn’t occur if the Subscriber is SQL Server 2008 R2 RTM. 

It has been reported to Microsoft and have recognized that it is a bug, which is fixed in Denali, but so far no date for the fix in 2008 R2.