MSDTC Setting Issue

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  January 7, 2015 at 1:41 am

  #313485

  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;-)

• adb2303

  SSCertifiable

  Points: 7588

  More actions

  January 7, 2015 at 2:09 am

  #1768359

  do you have those MSDTC settings on both ends?

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  January 7, 2015 at 2:21 am

  #1768363

  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

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  January 7, 2015 at 2:29 am

  #1768365

  same settings worked for me ..thanks

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  January 7, 2015 at 3:09 am

  #1768376

  Awesome! Glad I could help.

  -- Gianluca Sartori