How to fix Distributed Transaction Manager (MSDTC) has been disabled errors

sql-server windows-server-2008 msdtc
Jalpesh Vadgama picture Jalpesh Vadgama · Jan 12, 2010 · Viewed 56.8k times · Source

We are using transaction scope features of ASP.NET to manage distributed transaction for that we need to enable distributed transaction via following link:
The partner transaction manager has disabled its support for remote/network transactions

Its works well with SQL Server 2005 and Windows Server 2003 but when it comes to Windows Server 2008 server and SQL Server 2005 we are getting following error, still we followed the same steps provided in above link:

Windows Server 2008 + SQL Server 2005 + Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool.

Answer

Pongsathon.keng picture Pongsathon.keng · Feb 14, 2011

On my blog I discuss a fix: Fix MSDTC (Microsoft Distributed transaction coordinator)

This post will help you how set setup and check communication of MSDTC between servers. Please check:

  • Network
  • Firewall
  • ACL permission

You can config your severs and test the MSDTC by using following tool. DTCTester: http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q293799

Related questions

The MSDTC transaction manager was unable to pull the transaction from the source transaction manager due to communication problems

I have hosted my Webapp on server 1 and my database on server 2 But i m getting following error "Communication with the underlying transaction manager has failed." I googled and found a post which mentioned that it is the issue of …

Read More
Problems with MSDTC - remote transactions

We're in the process of moving our SQL Server to it's own machine, but I'm having issues getting transactions through MSDTC to work. Here is the error message ASP.Net is generating for me: The transaction manager has disabled its …

Read More
SQL Server Agent not starting automatically on server reboot

I have noticed that SQL Agent does not start automatically after a reboot/shutdown on a few of our servers (SQL server starts up fine). The service is set to automatically start in windows. When we start SQL agent manually, …

Read More