1 year ago

#48505

test-img

Jason Tracey

Linked servers throw error using MSOLEDBSQL. "Microsoft Distributed Transaction Coordinator (MS DTC) has stopped this transaction"

To replicate:

Download and install msoledbsql

msiexec /i msoledbsql.msi ADDLOCAL=ALL IACCEPTMSOLEDBSQLLICENSETERMS=YES

Create localdb servers

SQLLocalDB create a
SQLLocalDB create b 

In SSMS link servers using:

EXEC sp_addlinkedserver @server = '(localdb)\a', @datasrc = '(localdb)\a', @provider = 'MSOLEDBSQL', @srvproduct = ''

Create a dummy db and table in linked server.

CREATE DATABASE a;
USE [a]
CREATE TABLE [dbo].[TestTable](
    [id] [int] NULL
)

Attempt to query from the other

SELECT * FROM [(localdb)\a].a.[dbo].[TestTable]

Output

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

sql-server

linked-server

msdtc

0 Answers

Your Answer

Accepted video resources