Synchronizing data from a remote server database to a local database SQL Server 2008 Open distribution

Control Panel \ All Control Panel items \ Administrative Tools

Open "Component Services-Computer" by opening "Administrative Tools-Component Services" and right-click on "My Computer". On the MSDTC tab, click the "Security Configuration" button.

In the Security Configuration window, make the following settings:

• Select "Network DTC Access"

• In client management, select Allow remote clients to allow remote administration

L Select "Allow Inbound" "Allow Outbound" "Do not require authentication" in transaction management communication

L Ensure DTC Login account is: NT AUTHORITY\NetworkService

Http://www.cnblogs.com/yourancao520/archive/2012/02/28/2371231.html

Synchronizing data from a remote server database to a local database SQL Server 2008 Open distribution