July 10, 2013 at 8:04 am
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
July 10, 2013 at 10:22 am
First verify that DTC (Distributed Transaction Coordinator) is up and running properly on both(/all) instances.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.
July 10, 2013 at 2:26 pm
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]
July 11, 2013 at 8:17 am
Scot - your suggestion worked. I had to enable the MSDTC service and now the distributed queries run.
Thanks for the pointer !
🙂
July 11, 2013 at 8:55 am
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) A socialist is someone who will give you the shirt off *someone else's* back.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply