BizTalk Server Orchestration - New transaction cannot enlist in the specified transaction coordinator

Author

New transaction cannot enlist in the specified transaction coordinator

medhanush@yahoo.com

2006-01-09, 10:58 pm

Hi,

getting following error in event log, when orchestrations run a sql
adapter send updategram,

"New transaction cannot enlist in the specified transaction
coordinator."

looked at other posts, they have recommended following steps, tried all
of them, still didn't resolve issue

BTS box is standalone machine, whereas SQL 2005 is in a domain, does
this cause any issue ?

DTCPing able to ping each other
verified to have both same version of mdac
update lmhosts.sam file,
updated MSDTC properties in Component Services

configurations of both boxes
---------------------------
Windows 2003 SP1
BTS 2004
MDAC 2.8 SP2

Windows 2003 SP1
SQL 2005
MDAC 2.8 SP2

Any other ideas....
TIA
MeDhanush