Enabling DTC and BizTalk Server-优快云博客

本文介绍了当BizTalk Server 2004指向远程SQL Server时可能出现的“交易管理器不可用”错误，并提供了详细的解决步骤，包括如何设置DTC客户端网络访问、使用DTCTester工具测试安装以及调整Windows Server 2003 SP1中MSDTC的设置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Enabling DTC and BizTalk Server 2004

I'm sure I've written about this; at the least, it's in my install documentation and also the Official Microsoft BizTalk Installation documentation.

When firing BizTalk up pointing to a remote SQL Server, you might see the following error: "The transaction manager is not available".

I'm careful to point out you must set client network access for DTC in my installation documentation. I also found reference to a MS article titled “How to enable network DTC access in Windows Server 2003“. Be sure to restart DTC when you've finished the configuration steps.

I located a link to “How To Use DTCTester Tool“, which contains a DTC Test application and instructions on how to set it up to test your DTC installation is configured correctly.

Windows Server 2003 SP1 invited the Windows Firewall into the mix, so configuring network DTC is all the more important on both the BizTalk and MSSQL servers. I have a few details which I'll provide later, but here are two MSDN articles that helped me:

How to adjust the MSDTC settings:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/deploying/htm/ebiz_depl_assemblies_tfrh.asp?frame=true

MSDTC Changes in Windows 2003 SP1:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cossdk/html/2627a956-60b3-4d26-bc04-e0676ec97786.asp