One of the line of business applications used by a few clients performs updates to both it’s own database and also the Microsoft Dynamics GP database. It does this using code in SQL stored procedures which use transaction boundaries.
As the updates are between SQL servers, it does this using BEGIN DISTRIBUTED TRANSACTION rather than the usual BEGIN TRANSACTION; updates of this sort are, as stated in the name, distributed and required the Distributed Transaction Coordinator (DTC) Windows component to be enabled, which it is not by default, on both servers.
However, enabling DTC is straightforward and quick to do. Launch Component Services and expand the nodes () and right click on Local DTC; select Properties:
Continue reading “Enable the Windows Distributed Transaction Coordinator”