New transaction cannot enlist in specified transaction coordinator

New transaction cannot enlist in specified transaction coordinator

  • Comments 18

Seems like my day was dedicated to this error message! Ran into it while setting up some tests and we just couldn't get to the bottom of it. Here are some of the more interesting things I discovered while looking into this issue.

For starters there is this very useful KB article which guides you through various DTC related issues and how to identify them. The tool mentioned (DTCPing) was useful in ironing out some other issues, but not the main problem. The fascinating part was that the tool almost passed - we got an innocuous looking error followed by a message of the RPC test being a success. Here is what the error message looked like:

Error(0x2AFC) at nameping.cpp @62
-->gethostbyaddr
-->183(Cannot create a file when that file already exists.)

Interestingly, a colleague pointed me to an article dedicated to this very innocent looking error message. Wonders never seize! J

Anyway – this too did not get us all the way. After more head banging (and trying stunts like attempting to uninstall/reinstall MSDTC (which in retrospect might not have been too good an idea, since it can seriously screw up the system)) what finally solved the issue was opening up of more ports through Component Services à My Computer Properties à Default Protocols à Connection Oriented TCP/IP à Properties.

P.S. - One tool which would be useful in Windows - something that showed what ports were open/closed and were being used by which applications/services etc. Maybe there is tool out there which actually does that – Anyone?

/*********************************************************************/

This posting is provided "AS IS" with no warranties, and confers no rights.

/*********************************************************************/
Leave a Comment
  • Please add 2 and 6 and type the answer here:
  • Post
  • If your ambient is Development, so simply try to change the Require transaction option from the Transaction tab from the component property. Try this when you do not need transaction context in development time.

  • hmm, no luck, your sugggestions did not work for me for my win 2k server. I still get the error. One setting that I found to be different  is the Default Impeorsantion level which is set to Identity on the machine(PROD) I am getting error and anonymous on the machine(DEV) where it is working fine. Any inputs?

  • Hi all. Similarly tried to insert into lcl.tableA select from linkedsrvr.tableB, and had this error. lcl.TableA had a trigger.

    Used a select into statement (from lkdsrvr.tableB into lcl.tableC) then went from TableC into TableA successfully.

    Methinks the trigger is the culprit in my instance.

    Kind regards H

Page 2 of 2 (18 items) 12