Error 7391; Unable to Begin a Distributed Transaction

• chaitanyagoa

  Mr or Mrs. 500

  Points: 536

  More actions

  November 5, 2010 at 7:39 am

  #226050

  Hey All,

  I am trying to get a list of error messages on a server using the sp_readlogerror stored procedure. I have a central server A and I am trying to get the information from Server B.

  exec [server B].model.sys.sp_readerrorlog

  the above statement works well and gets the data, But it throws up a transaction error when i try to insert into a temp table on server A. Here is the code running on server A:

  create table #ErrorLog(LogDate datetime, ProcessorInfo varchar(1000),Text varchar(5000))

  insert into #errorLog

  exec [Server B].model.sys.sp_readerrorlog

  this Throws up a transaction error as below

  OLE DB provider "SQLNCLI" for linked server "BHSF-BTR-W318" returned message "The partner transaction manager has disabled its support for remote/network transactions.".

  Msg 7391, Level 16, State 2, Line 3

  The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "BHSF-BTR-W318" was unable to begin a distributed transaction.

  Any Suggestions???

  Thanks for the Help

  Chitanya Chitturi :-)

• chaitanyagoa

  Mr or Mrs. 500

  Points: 536

  More actions

  November 5, 2010 at 8:37 am

  #1247164

  Guys,

  I think i found the solution.... will post it in a few minutes....

  Chitanya Chitturi :-)

• chaitanyagoa

  Mr or Mrs. 500

  Points: 536

  More actions

  November 5, 2010 at 9:08 am

  #1247182

  Here is the link for the solution:( i could not upload the image here; Hence giving the link of my Blog...)

  http://iamadba.blogspot.com/2010/11/unable-to-begin-distributed-transaction.html

  Chitanya Chitturi :-)

• ramu.valmiki07

  SSC Rookie

  Points: 43

  More actions

  March 6, 2013 at 10:07 pm

  #1594274

  Hii to all,

  Iam also facing the similar problem,when iam executing the trigger with openquery iam finding the following error,i have tried with ur above steps,still iam facing the below error

  Error:-"OLE DB provider "MSDASQL" for linked server "SQLMYSQL" returned message "[MySQL][ODBC 3.51 Driver]Optional feature not supported".

  Msg 7391, Level 16, State 2, Procedure MYSQLLogRecords, Line 11

  The operation could not be performed because OLE DB provider "MSDASQL" for linked server "SQLMYSQL" was unable to begin a distributed transaction"

  I have already configured DTC it is running fine,please help me how to overcome the above error

  Thanks

  Ramu