Programming, SQL, SQL Server 2008, Windows 2003, Windows 2008

Troubleshooting MSDTC: The transaction manager has disabled its support for remote/network transactions

While rolling out a large stored procedure to our test servers today Luvy and I got a cryptic seeming server communications error message indicating there is a problem with the MSDTC settings.

The transaction manager has disabled its support for remote/network transactions

At first we thought this had something to do with the linked server we were using. However after testing out the various server option settings and checking for similar errors on Google it became clear that the error was due to configuration issues on the servers housing our SQL server databases.

One of the servers is Windows 2008 and the other is Windows 2003 R2, so finding the locations of the settings was different between the two machines.

The first set of steps was that we had to check the running services. On both machines this was the same:

  1. Click Start -> Administrative Tools -> Services
  2. In the Services popup look for the service called ‘Distributed Transaction Coordinator’ and make sure it is running

Secondly we had to check the MSDTC options on the computer. Continue reading “Troubleshooting MSDTC: The transaction manager has disabled its support for remote/network transactions”