Error:"A Microsoft Distributed Transaction Coordinator problem prevented connection to the Configuration database. The transaction has already been implicitly or explicitly committed or aborted"

 

CAUSE

This behavior occurs because Remote Procedure Call (RPC) security requires that the computer that is running SQL Server 2000 and the BizTalk Server 2004 computer exist in the same Active Directory domain. RPC security is used for Data Transaction Coordinator (DTC) authentication between BizTalk 2004 computers.

WORKAROUND

Warning If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

To work around this behavior, turn off the RPC security on your Windows Server 2003 computers. To do this, set the DWORD value for the TurnOffRpcSecurity registry value to 1:

1.	Click Start, and then click Run.
2.	In the Open box, type regedit, and then click OK.
3.	Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\TurnOffRpcSecurity Note If this subkey does not exist, create this subkey.
4.	On the Edit menu, click Modify.
5.	In the Value data box, type 1, and then click OK.
6.	Quit Registry Editor.

MORE INFORMATION

RPC security is a new DTC feature in Windows Server 2003. When you disable RPC security, the DTC authentication security level for RPC calls goes back to one that is available in Microsoft Windows 2000 Server.