Sunday, July 22, 2007

New transaction cannot enlist in the specified transaction coordinator

I was faced with this error when I was trying to configure a web application and trying enter a transaction through the virtual website. Thanks to the internet, I found a lot of information on the internet.

Here are the steps I followed to correct this:

Start the Component Services administrative tool. To do this, click Start, click Run, type dcomcnfg.exe, and then click OK.
In the console tree of the Component Services administrative tool, expand Component Services, expand Computers, right-click My Computer, and then click Properties.
Click the MSDTC tab, and then click Security Configuration.

Turn on the Network DTC Access
Allow Inbound
Allow Outbound
Enable XA Transactions
Choose No Authentication required

Save these settings and reboot your system.

The error is fixed.

In Windows Server 2003 SP1 and in Windows XP SP2, the Distributed Transaction Coordinator service gives you more control over the network communication between computers. By default, all network communication is disabled. The Distributed Transaction Coordinator Security Configuration dialog box has been enhanced so that you can manage these communication settings.

2 comments:

Hyderabad said...

I have the same problem, but I am not able to see the security settings mentioned by you on my Win 2K Server.

nam3508 said...

I am experiencing the issue of DTS pump not allowing enlist into transaction. Followed your instructions and the settings needed adjusting as you described. Thanks a bunch.

Step By Step Guide to resolve SQL server connection issues when connecting from R Studio

Yesterday I tried using a couple of  RevolveScaleR functions -- RxSqlServerData and RxImport.in Rstudio.  These are my learnings as part of ...