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.

image

Choose the MSDTC tab and then at the bottom of the window click the Security Configuration button.

image

In this window, change the setting under Transaction Manager Communication to “No Authentication Required”.

image

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.

Lowell Heddings Lowell Heddings
Lowell is the founder and CEO of How-To Geek. He’s been running the show since creating the site back in 2006. Over the last decade, Lowell has personally written more than 1000 articles which have been viewed by over 250 million people.
Read Full Bio »