Fix "New transaction cannot enlist in the specified transaction coordinator" on Server 2003 SP2
If you are running a web application using the original ASP technology on Windows Server 2003, you might get this error message once you upgrade to Service Pack 2: "New transaction cannot enlist in the specified transaction coordinator. [-2147168246]".
The cause for this error is that MSDTC has a setting that requires authentication for distributed transactions, and the upgrade to SP2 might change the setting to required instead of none.
To fix this error, open Component Services and right-click on the My Computer icon and choose properties.
Choose the MSDTC tab and then at the bottom of the window click the Security Configuration button.
In this window, change the setting under Transaction Manager Communication to "No Authentication Required".
This should resolve this error.
Note that if you have a firewall between the web server and database server then you should ensure that high ports are open between the two machines, along with RPC, as that could also cause the same error.
Thanks for publishing this article. Looks like it has fixed an issue we've had with our production server for 3 weeks now!
Thanks a lot! This fixed our problem right away.
Hi,
I have the same problem, but it is with a win 2K Server, and it seems the 2K server does not have the security settings that you mentioned. So what could be wrong with the 2k server. Things were working fine till a few weeks back, but all of a sudden we started getting this error for some of the COM components.
Hellooooo! Anyone actually stopped to think as to WHY the base setting is Athentication Required? Mabye that is a good idea? Maybe you shouldn't just turn it off.
That is all
Really good article