BizTalk Server General - SQL Server Adapter Remote error(BTS06+SQL 2005)

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > April 2006 > SQL Server Adapter Remote error(BTS06+SQL 2005)





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author SQL Server Adapter Remote error(BTS06+SQL 2005)
AlanYu

2006-04-10, 7:34 pm

Hi All,

I got the error "New transaction cannot enlist in the specified transaction
coordinator." when use SQL Server Adapter romote with SQL Server 2005. it is
fine use with the SQL Server on local computer. I find the similiar error
before but still no idea

http://www.microsoft.com/technet/co...cc-1d70918ca29a

http://nealwalters.blogspot.com/200...-my-client.html

Thanks,
Alan
potocki

2006-04-10, 7:34 pm

You probably must run the DTC access from you Distributed Transaction
Coordinator.
To turn DTC Access on :
>From the Start menu, double-click Control Panel, double-click

Administrative Tools, and then double-click Component Services.
Expand Component Services, and then expand Computers.
Right-click the computer you need to set, and from the context menu
select Properties.
In the Properties window, select the MSDTC tab.
In the Transaction Configuration area, click Security Configuration.

In the Security Settings area, make sure the Network DTC Access check
box is selected.
In the Security Settings area, check the Network Clients check box.
Click OK on each open dialog box.
Restart your computer to enable the remote DTC option.

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com