Distributed Transaction Help

• Sean Pearce

  SSCoach

  Points: 15999

  More actions

  July 30, 2014 at 3:51 am

  #289386

  Please assist with any ideas beyond the fixes I have already tried, listed below:

  The Error

  [OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]

  OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].

  Msg 7391, Level 16, State 1, Line 2

  The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.

  The system I am running the query on

  Microsoft SQL Server 2000 SP4 Enterprise Edition

  8.00.2065

  Windows Server 2003 Enterprise Edition

  Intel X86

  The linked server

  Microsoft SQL Server 2008 R2 SP1 Standard Edition

  10.50.2550.0

  Windows Server 2008 R2 Standard Edition

  Intel X64

  Code to reproduce error

  SET XACT_ABORT ON;

  GO

  BEGIN DISTRIBUTED TRANSACTION;

  SELECT * FROM [TheLinkedServer].master.sys.tables;

  COMMIT TRAN;

  GO

  The following have been checked

  I am able to ping each other using computer name

  I am able to telnet to port 135

  Firewall is not running on both sides

  MSDTC is running on both sides

  MSDTC is running under the Network Service account

  MSDTC is enabled for network transactions

  Both Allow Inbound and Allow Outbound are enabled

  @@SERVERNAME matches the server name on both sides

  Thanks in advance

  

  The SQL Guy @ blogspot[/url]

  @SeanPearceSQL

  About Me[/url]