If above test is failing, then make sure you follow the KB article 2027550 and make setting as shown below:īelow are some errors which I have seen in this regards in the past: Whenever I get any DTC errors while working with linked server, the very first test I perform is by doing the dummy distributed transaction to see whether DTC between two servers is working or not. Initially I thought it was due to misconfigured DTC between source and destination, but digging more into this error revealed something really interesting and again I learned something new. The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.
While working via linked server to do data manipulation they reported this error on their servers: Msg 1206, Level 18, State 118, Line 9 Here is an error that was shared at one of the User group meetings by a member. The saga of working with error messages continues.
