The operation could not be performed because OLE DB provider ... for linked server ... was unable to begin a distributed transaction (SQL Compare)

This error occurs because of the Transaction Isolation Level.

By default, SQL Compare uses the Serializable Transaction Isolation Level, however this deployment requires a Transaction Isolation Level of Read Committed.

This documentation goes into more detail:

https://documentation.red-gate.com/sc/troubleshooting/error-messages/the-operation-could-not-be-performed-because-the-ole-db-provider-sqloledb-was-unable-to-begin-a-distributed-transaction 

Was this article helpful?

1 out of 1 found this helpful
Have more questions? Submit a request