linked server issue

Question

linked server issue

PearlJammer1

SSCrazy Eights

Points: 8495
More actions
July 10, 2013 at 8:04 am

#279659

Hi
Can anybody advise on the following error :
OLE DB provider "SQLNCLI10" for linked server "server1" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Line 2
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "server1" was unable to begin a distributed transaction.
Any pointers would be great. Thanks

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

ScottPletcher SSC Guru Points: 101200 More actions · Answer 1

First verify that DTC (Distributed Transaction Coordinator) is up and running properly on both(/all) instances.

SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

Erland Sommarskog SSC-Insane Points: 24038 More actions · Answer 2

It helps if you give the context. What do you try to do? Do you need the distributed transaction?

Also, are the two servers in the same domain? In a workgroup? In different domains with trust? Different domains without trust?

[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

PearlJammer1 SSCrazy Eights Points: 8495 More actions · Answer 3

Scot - your suggestion worked. I had to enable the MSDTC service and now the distributed queries run.

Thanks for the pointer !

🙂

ScottPletcher SSC Guru Points: 101200 More actions · Answer 4

PearlJammer1 (7/11/2013)
Scot - your suggestion worked. I had to enable the MSDTC service and now the distributed queries run.
Thanks for the pointer !
🙂

No problem. That's the most common fix, and luckily the easiest as well :-).

SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".