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: Friday, September 26, 2014 9:36 AM
Points: 244, Visits: 965
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 @ 4:15 PM
Points: 2,120, Visits: 3,202
First verify that DTC (Distributed Transaction Coordinator) is up and running properly on both(/all) instances.

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

Carl Sagan said: "There is no such thing as a dumb question." Sagan obviously never watched a congressional hearing!
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: Wednesday, September 24, 2014 1:24 PM
Points: 805, Visits: 722
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: Friday, September 26, 2014 9:36 AM
Points: 244, Visits: 965
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 @ 4:15 PM
Points: 2,120, Visits: 3,202
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)

Carl Sagan said: "There is no such thing as a dumb question." Sagan obviously never watched a congressional hearing!
Post #1472627
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse