While attempting to deploy a very simple BizTalk 2006 application from my (Windows XP SP2) development machine running VSTS 2005 to my (Windows 2003 SP1) BizTalk 2006/SQL 2005 server, I received several MSDTC errors such as:
MSDTC may not be configured correctly --or-- Access Denied --or-- Failed to add resource (Luid="System.BizTalk:BizTalkAssembly", Type="MyBizTalkProject, version=1.0.0.0,....). Cannot open database BizTalkMgmtDb on server MyBizTalkServer. etc...
To resolve this issue...
First I made sure I could ping both server-->dev machine and dev machine-->server with their NetBios names to that was working. (If that doesn't work you may have to your ICMP setting are set to allow ping requests and also "Enable NetBios over TCP/IP" via your Network adapter's TCP/IP Properties/Advance (button)/WIN (tab).
Second ensured that both the (biztalk and sql) server and (vsts) developer machine had all the appropriate MSDTC settings as follows:
To enable DTC access for Windows Server 2003 with SP1 or Windows XP with SP2, do the following:
To enable DTC access for Windows Server 2003 without SP1, do the following:
When I completed this task my MSDTC errors were still not resolved and could not deploy the BizTalk assembly, so I attempted to test my DTC connections from both the server and developer machine using DTCPing.exe which did little but reconfirm that I was have Access Denied and DTC binding issues.
Finally I after playing around with disabling my firewall and antivirus (which worked, but left my computer vulnerable), I completed the following steps to get everything working:
Configure Windows Firewall to include the MSDTC program and to include port 135 as an exception. To do this, follow these steps: