SQL Compact Merge replication no longer works after VS SP1 is installed

Tech-Archive recommends: Fix windows errors by optimizing your registry



I have 2 separate machines that recently had a clean install. Both machines
are Windows XP SP3 with Visual Studio 2008. I have a project that uses SQL
Compact Merge replication to a backend SQL 2005 database; In each case after
installing VS 2008 SP1 the merge replication gives the following error after
calling the synchronize methoed of the SqlCeReplication object.

When I reproduced this on machine #2 I verified that the merge process ran
fine before the SP install. Immediately after installing VS 2008 SP1 and
re-running my project I get the same error that I was getting on my primary
development machine.

Any help would be greatly appreciated as I think my only option is to
remove VS SP1?

Error Code: -2147201019
Message: Initializing SQL Server Reconciler has failed. Try again.
Minor Error: 29045
Source: Microsoft SQL Server Compact
------------------

Error Code: -2147198719
Message: The merge process could not connect to the message file from
Subscriber XXXX Check to ensure that the server is running.
Minor Error: 0
Source: Merge replication provider.
------------------

Error Code: -2147201019
Message: The subscription to publication 'Interlink' could not be verified.
Ensure that all Merge Agent command line parameters are specified correctly
and that the subscription is correctly configured. If the Publisher no
longer has information about this subscription, drop and recreate the
subscription.
Minor Error: 0
Source: Merge Process (Web Sync Server)



.



Relevant Pages