现象:在进行SQLSERVER事务复制时,创建链接服务器时报告MSDTC不可用
就去查看事件日志,发下以如下错误信息:
The local MS DTC detected that the MS DTC on MYDAVINCI20 has the
same unique identity as the local MS DTC. This means that the two
MS DTC will not be able to communicate with each other. This
problem typically occurs if one of the systems were cloned using
unsupported cloning tools. MS DTC requires that the systems be
cloned using supported cloning tools such as SYSPREP. Running
'msdtc -uninstall' and then 'msdtc -install' from the command
prompt will fix the problem. Note: Running 'msdtc -uninstall' will
result in the system losing all MS DTC configuration
information.
故障原因:
克隆的机器会使DTC协调器的一个GUID唯一标识出现相同的现象,从而导致网络中找到两个同一标识的DTC服务器,这样就可能会给K/3客户端的访问带来问题,如果是这样的情况,可以重新安装msdtc进行修复:在命令行运行msdtc
–uninstall,重启机器,运行msdtc –install重新安装。
最终问题解决。