让数据库复制用到的MSDTC通过防火墙

1. MSDTC在每个系统中都有一个唯一标识，如果是克隆的系统（如：Copy虚拟机文件，ghost等方式）会造成MSDTC工作不正常。请大家尤为注意。

2.MSDTC与hosts文件有相当在的关系

3.让MSDTC通过firewall(脚本）

以Windows防火墙为例：

netsh firewall add portopening TCP 5000 blah enable subnet
netsh firewall add portopening TCP 5001 blah enable subnet
netsh firewall add portopening TCP 5002 blah enable subnet
netsh firewall add portopening TCP 5003 blah enable subnet
netsh firewall add portopening TCP 5004 blah enable subnet
netsh firewall add portopening TCP 5005 blah enable subnet
netsh firewall add portopening TCP 5006 blah enable subnet
netsh firewall add portopening TCP 5007 blah enable subnet
netsh firewall add portopening TCP 5008 blah enable subnet
netsh firewall add portopening TCP 5009 blah enable subnet
netsh firewall add portopening TCP 5010 blah enable subnet
netsh firewall add portopening TCP 5011 blah enable subnet
netsh firewall add portopening TCP 5012 blah enable subnet
netsh firewall add portopening TCP 5013 blah enable subnet
netsh firewall add portopening TCP 5014 blah enable subnet
netsh firewall add portopening TCP 5015 blah enable subnet
netsh firewall add portopening TCP 5016 blah enable subnet
netsh firewall add portopening TCP 5017 blah enable subnet
netsh firewall add portopening TCP 5018 blah enable subnet
netsh firewall add portopening TCP 5019 blah enable subnet
netsh firewall add portopening TCP 5020 blah enable subnet

保存为filename.bat

2.修改注册表，创建键值使用以下脚本

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Rpc\Internet]
"Ports"=hex(7):35,00,30,00,30,00,30,00,2d,00,35,00,30,00,32,00,30,00,00,00,00,\
  00
"PortsInternetAvailable"="Y"
"UseInternetPorts"="Y"
保存为 filename.reg。

3. 直接双击执行即可