Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

linked server issue Expand / Collapse
Author
Message
Posted Wednesday, July 10, 2013 8:04 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 4:49 AM
Points: 242, Visits: 961
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
Post #1472165
Posted Wednesday, July 10, 2013 10:22 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:14 PM
Points: 2,098, Visits: 3,155
First verify that DTC (Distributed Transaction Coordinator) is up and running properly on both(/all) instances.

SQL DBA,SQL Server MVP('07, '08, '09)

"We came in spastic, Like tameless horses /
We left in plastic, As numbered corpses / ...
Remember Charlie, Remember Baker /
They left their childhood On every acre /
And who was wrong? And who was right? /
It didn't matter in the thick of the fight." : the inimitable Mr. Billy Joel, about the Vietnam War
Post #1472237
Posted Wednesday, July 10, 2013 2:26 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, September 15, 2014 4:57 AM
Points: 802, Visits: 717
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?


Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1472358
Posted Thursday, July 11, 2013 8:17 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 4:49 AM
Points: 242, Visits: 961
Scot - your suggestion worked. I had to enable the MSDTC service and now the distributed queries run.

Thanks for the pointer !

Post #1472599
Posted Thursday, July 11, 2013 8:55 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:14 PM
Points: 2,098, Visits: 3,155
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)

"We came in spastic, Like tameless horses /
We left in plastic, As numbered corpses / ...
Remember Charlie, Remember Baker /
They left their childhood On every acre /
And who was wrong? And who was right? /
It didn't matter in the thick of the fight." : the inimitable Mr. Billy Joel, about the Vietnam War
Post #1472627
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse