Forum Discussion

Copper Contributor

May 15, 2025

Linked Server Selection Query Fails with "MS DTC has stopped this transaction"

Hi everyone, I’m currently setting up a Linked Server from our head office (server A) SQL Server to a subsidiary unit (Server B) SQL Server. The Linked Server connection tests successfully, and I c...

Copper Contributor

May 16, 2025

execute me, could you guys give me solution for that error?

Neb12
Copper Contributor
May 30, 2025
You might need to turn on AdHoc distributed queries:

EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
RECONFIGURE;