BizTalk Server General - SQL Adapter Requirements on BT2004

Author

SQL Adapter Requirements on BT2004

BT User

2004-04-01, 1:42 pm

I am trying to send an updategram to a server located in our network but not
in the same domain. Both Biztal and the destination server have MDAC 2.8,
and MSDTC is running as well.

However, I'm getting the message <The adapter "SQL" raised an error message.
Details "New transaction cannot enlist in the specified transaction
coordinator. ".> when sending the updategram over. I am able to connect to
the destination server without any problems using Query Analyzer. Indeed, I
can even set up the send port to this server successfully. The only thing
I'm not sure about it whether SQLXML SP1 is installed on the server. Is
this a requirement for all SQL servers that are interacting with Biztalk
now?