In the previous article, SQL Server 2005/2008 merged and copied step by step.ArticleThe text explains how to use SQL Server's replication function step by step. If the replication test is performed on the same machine (the same machine is both a publisher and a subscriber), it is easy to pass the test. However, when I perform tests on different machines and create a release on one machine, I cannot create a subscription on another machine.
In this process, the following problems have occurred: many problems and errorsCodeNot clear.
1. The transaction manager has disabled its support for remote/network transactions
2. No transaction is active
......
Although there are many problems, the subscription problem is finally solved after multiple attempts.
1. Disable the firewall first (completely)
2. the DTC service (Distributed Transaction Coordinator) is enabled on both machines)
3. Check whether port 135 is enabled on the machine,CMD-> Netstat-a-n. Open port 135 if not.
4. If the firewall is not disabled, set allowProgramUse the DTC service, such
5. Set MSDTC
(1) choose Start> Control Panel> Administrative Tools> component services to go to the following interface:
Select "Local DTC"-> right-click Properties to bring up a tab panel. The settings in the tab are as follows (tracing and security settings ):
6. Restart the DTC service after the settings are complete.