I tried to synchronize the Database between 2 Servers using Red Gate Compare, I am getting the following error.
Anybody got that error before? Do you know how to resolve that issue?
asked Nov 29 '10 at 04:51 AM in Default
It sounds like the Distributed Transaction Coordinator (DTC) must be offline on the server. Or, DTC is set to not allow remote connections. Either way, you'll need to go to the server to do this.
Is is possible you're running SQL Compare across different domains? I only ask because I wouldn't have expected it to need to do a distributed transaction... unless there are also linked servers involved, maybe... Not sure about that.
answered Nov 29 '10 at 05:23 AM
Grant Fritchey ♦♦