Hello,

I'm using BizTalk 2006 SQL Adapter to insert and retreive data from MS SQL
Server 2000 DB, BizTalk are installed on Windows Server 2003 R2 SP2, and SQL

Server 2000 is installed on windows Server 2003 SP1, firewall are disapled
in both servers, the MSDTC are running and configured with "no authenticatio
n

required" and Allow Inbound and Allow Outbound options on both servers, the
DTC login account is "Network Service".
RPC Security for MSDTC Service are disabled.

I used the "dtctester.exe" tool to check the MSDTC, and it secceeded.
Both servers are using TCP/IP rather than Named Pipes.

I'm getting the following error message:

A message sent to adapter "SQL" on send port "SendPort2" with URI
"SQL://10.8.1.231/CRMDB/" is suspended.
Error details: HRESULT="0x80040e14" Description="The operation could not be
performed because the OLE DB provider 'SQLOLEDB' was unable to begin a

distributed transaction."
HRESULT="0x80040e14" Description="OLE DB error trace [OLE/DB Provider
'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a]."
HRESULT="0x80040e14" Description="[OLE/DB provider returned message: New
transaction cannot enlist in the specified transaction coordinator. ]"

[ Post a follow-up to this message ]