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.

Two ways to reset the identity of a table in sql server.

I know of the following two ways to reset the identity of a table in sql server. You often tend to use dummy data during the course of y...