Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL Adapter Problem - DTC

39 views
Skip to first unread message

TimG

unread,
Nov 21, 2004, 11:53:01 PM11/21/04
to
Hi

I have published an orchestration as a web service running on a machine with
BTK 2004 and Win 2003. The orchestration calls a stored procedure on a remote
SQL Server. In the event viewer I am getting the warning

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

and then a couple of unhelpful failed messages


Everthing works ok if biztalk is on a win xp machine. Any help would be most
appreciated (DTC) is running both on SQL Server and the BizTalk machines

Regards

Tim


Alan Smith

unread,
Nov 22, 2004, 3:15:09 AM11/22/04
to
Hi Tim,

I have run into a similar problem. By default, Server 2003 dissabled network
DTC access. To enable it manually, try the following:

In Add Remove Programs/Windows Components, select Application Server, and
check Enable COM+access, and Enable Network DTC access.

Select Component Services from the Admin Tool, select My Computer,
properties MSDTC, then Security Configuration. Check Network DTC Access,
Netwrk Administration, Network Transactions, and Network Clients.

I think you need to have these settings on both boxes, and you may need to
reboot after changing the settings. I'm not sure if these are the optimal
settings but they seem to work for me. I have seen several different
configurtions recommended in different BizTalk docs and whitepapers, I'd love
to know the correct settings...

Hope this helps,

Alan

Niklas E

unread,
Nov 22, 2004, 4:57:11 AM11/22/04
to
The DTCPing.exe and DTCTest.exe tools might help you in your debugging if
you haven't tried them:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306843

http://support.microsoft.com/default.aspx?scid=kb;en-us;293799

Make sure you have applied the post sp3 hotfix (2000.80.878.0) or later
which is part of the BizTalk installation guide as well on your SQL Servers.

This is a later version of SQL adapter as well, which might help you, but I
don't think the "cannot unenlist" is such a problem.
http://support.microsoft.com/default.aspx?scid=kb;en-us;841612

Best regards
Niklas E

"TimG" <Ti...@discussions.microsoft.com> wrote in message
news:C984460E-545A-42E9...@microsoft.com...

Anthony Odole

unread,
Nov 23, 2004, 12:33:03 AM11/23/04
to
Tim,

Use DTCPing to test DTC transactions on both systems. Sometimes people use
DTC ping and the problem persists. This is usually because you are not
testing the DTC connectivity from both system.
Let me know if you need more specific instructions.

Anthony


"TimG" <Ti...@discussions.microsoft.com> wrote in message
news:C984460E-545A-42E9...@microsoft.com...

TimG

unread,
Nov 23, 2004, 8:04:02 PM11/23/04
to
Thanks for the help

I applied SQL SERVER 2000 SP3A (I had already applied SP3) and now
everything seems to work ok.

Regards

Tim

Niklas E

unread,
Nov 24, 2004, 5:40:57 AM11/24/04
to
When we used DTCPing it returned success on both tests on both machines, but
nothing worked anyway. When we tested with the other util DTCTester, it
indicated some errors that were useful. So you might want to test with both
utils.

/Niklas E

"Anthony Odole" <anthon...@yahoo.com> wrote in message
news:OjuPN4R0...@TK2MSFTNGP10.phx.gbl...

0 new messages