MSOLEDBSQL Provider Linked Server

by MrTCS   Last Updated September 12, 2018 18:06 PM

I've added the MSOLEDBSQL provider to our SQL Server 2012 server to try and create a link server that can use MULITSUBNETFAILOVER=true. The problem is creating a query, even a simple select, fails with the error

"Microsoft Distributed Transaction Coordinator (MS DTC) has stopped this transaction."

I was able to get the query to finally run but have to explicitly use BEGIN DISTRIBUTED TRAN. Is there something I'm missing that would allow us to make this call without the BEGIN DISTRIBUTED TRAN?

I created a link server with the standard SQLNCLI provider to the same server and verified it works fine with just the select statement.

Related Questions

Availability groups and Linked Servers

Updated October 16, 2018 10:06 AM