Access Denied When Using MS SyncFramework

Navigation
1

I'm trying to implement a system where I need to have a local database (SQL Compact) and a cloud (MSSQL) database that can be synchronized. The form I found and followed is the one specified in this link .

But I have some problems when I host the WCF service on a dedicated server (in the IIS of my machine it is working).

The error found is as follows:

ExceptionDetail , probably created by IncludeExceptionDetailInFaults = true , whose value is:

  

System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID (EC413D66-6221-4EBB-AC55-4900FB321011) failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)). at Microsoft.Synchronization.SyncIdFormatGroup.get_ProviderSyncServices ()

Has anyone ever had a similar error? Or do you know a simpler way to implement this?

    
asked by anonymous 30.05.2014 / 20:43

1 answer

1

Regarding the error

Most likely, IIS is attempting to load one of the SyncFramework libraries that is not installed on the server.

Try installing / reinstalling redistributable on the server (x86 / x64 depending on your server).

SyncFramework alternative

An alternative to SyncFramework is to use SSIS (Sql Server Integration Services).

SISS provides graphical interface that you can use to draw what you are trying to do (and the SISS package can run SQL commands to solve data duplication / conflicts, etc.). You can then schedule the package to run in a SQL Server Job when needed.

(personal opinion from this moment)

I used both the technology but much more SyncFramework and the problem I faced is the technical overhead needed to create and maintain a solution done with this framework.

>

If you have the opportunity, explore the idea of SSIS and bearing in mind that support for this functionality is greater than for SyncFramework.

    
30.05.2014 / 22:07
Error publishing to a facebook fanpage using php API Zoom Levels Google Maps