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:
- Click Start -> Administrative Tools -> Services
- 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”