January 7, 2015 at 1:41 am
Please help.. i have window 2008 R2 OS , Sql server 2012 edition
Please see the MSDTC settings too (see attachment)
Two Sql server instances trying to communicate (Distributed tran)
begin distributed transaction
select * from [cvent_report].master.dbo.sysprocesses
Commit Transaction
OLE DB provider "SQLNCLI11" for linked server "cvent_report" 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 "SQLNCLI11" for linked server "cvent_report" was unable to begin a distributed transaction.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 7, 2015 at 2:09 am
do you have those MSDTC settings on both ends?
January 7, 2015 at 2:21 am
Some years ago I wrote an article on setting up a linked server with out-of-process OLEDB provider. It's not exactly what you're after, but it contains information on how to set up the DTC that you may find useful.
Here's the article: http://www.sqlservercentral.com/articles/Linked+Servers/73794/
-- Gianluca Sartori
January 7, 2015 at 2:29 am
same settings worked for me ..thanks
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 7, 2015 at 3:09 am
Awesome! Glad I could help.
-- Gianluca Sartori
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply