Developer Forum

by **wask** » Wed, 07 Dec 2005 04:44:24

Hi

I am getting the following error message in the Event Viewer when using
an Updategram to insert into a table on a remote SQL Server Machine and
receive data from table in receive port on remote SQL server.

The adapter "SQL" raised an error message. Details "New transaction
cannot enlist in the specified transaction coordinator. ".

The SQL Server machine is running Windows 2000
BizTalk 2004 machine is running windows 2003 with Network DTC Access
turned on for Network Admin & Network Transactions.

Thanks for the help.

wask

by **wask** » Wed, 07 Dec 2005 05:41:56

Hi

I am getting the following error message in the Event Viewer when using

an Updategram to insert into a table on a remote SQL Server Machine and

receive data from table in receive port from remote SQL server.

The adapter "SQL" raised an error message. Details "New transaction
cannot enlist in the specified transaction coordinator. ".

The SQL Server machine is running on remote Windows 2000 with cluster
BizTalk 2004 machine is running windows 2003 with Network DTC Access
turned on for Network Admin & Network Transactions.

I checked some article it say For W2K the defalut DTC Security on port
(3372) is open
For W2K3 the defalut DTC security on the port is closed.

Should i open 3372 port to connect remote SQL Server.

Thanks for the help.

wask

by **Mike Koern** » Wed, 07 Dec 2005 06:07:03

Hi,
I had a similar problem. Follow this kb
http://www.yqcomputer.com/
Be sure to reboot the SQL server after the completion.

Good luck.

Mike

by **wask** » Wed, 07 Dec 2005 06:27:25

Mike

Thanks for help.

Every thing set according to kb
( http://www.yqcomputer.com/

). But still i get same error.

thanks
wask

by **wask** » Wed, 07 Dec 2005 06:37:56

Mike

SQL Server is running on remote machine with windows 2000. My Biztalk
2004 server running on Windows 2003.

thanks
wask

by **Mike Koern** » Thu, 08 Dec 2005 02:17:02

Hi,

Still doesn't work?
We've used the DTC Tester tool before on a different machine.
http://www.yqcomputer.com/ ;en-us;293799

Please post back if you get it to work.

Good luck again.
Mike

by **McGeek** » Thu, 08 Jun 2006 16:53:33

Hi. We are receiving the error "New transaction cannot enlist in the
specified transaction coordinator" out of the blue by BizTalk when it
attempts to send a message to a SQL send adapter. We have BizTalk 2004
running on a Windows 2003 server sp1 calling a stored procedure on SQL
Server 2000 running on a separate Windows 2003 server also sp1.

Everything was working fine when it suddenly started erroring for each time
it used the send port. We checked MSDTC settings and they all look fine.

Has anyone seen anything like this?

--
McGeeky
http://www.yqcomputer.com/

by **McGeek** » Thu, 08 Jun 2006 18:44:23

Issue resolved. Someone had been changing low level network settings
somewhere which suddenly meant that NetBIOS was not working for the server -
ping would not even work. MSDTC is dependent upon the NetBIOS name of the
server being accessible. Bizarelly nothing else was impacted, only MSDTC.

We raised this issue to the network team - they changed something back and
it all worked fine. Relief!

Hope this helps someone else in the future.

--
McGeeky
http://www.yqcomputer.com/

Developer Forum

New transaction cannot enlist in the specified transaction coordinator