Multiple Connections - different servers - Linked Server - unable to begin a distributed transaction
I'm using multiple connections in Linqpad to read and write to the same DB on different servers.
Ordinarily, Linqpad only supports multiple connections to different databases on the same server. Using a Linked Server gets around this issue.
I've setup the Linked Server in SQL Server Management Studio, and I can happy interact with the MSSQL server as a "Linked Server"
I've also setup the DB connection in Linqpad and added the "linked server" using the "include additional databases" section on of the Linqpad Connection dialog.
However, when I try to write with the linked server, I get this error....
SqlException: The operation could not be performed because OLE DB provider "MSOLEDBSQL" for linked server "SERVERNAME.COM" was unable to begin a distributed transaction.
OLE DB provider "MSOLEDBSQL" for linked server "SERVERNAME.COM" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
Reading from the linked server works fine