The partner transaction manager has disabled its support for remote/network transactions

Question

Post reply

The partner transaction manager has disabled its support for remote/network transactions

ritesh.saluja

SSCommitted

Points: 1704
More actions
April 26, 2009 at 10:53 pm

#208544

In one SSIS package, I m using sequence container with transaction option = required.
The sequence container contains the task which executes the stored procedure.
This SSIS works fine when I refer to SQL DB locally.
But if I point the package to remote DB (from other machine) then it gives me error.
The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D025
If I change the Sequence container transaction property from Required to Supported then I am able to point the package to remote machine DB.
Please suggest how to make the package working with Required transaction option for Sequence container and point it to remote machine DB
thanks

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246988 More actions · Answer 1

This thread might help you:

http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/7172223f-acbe-4472-8cdf-feec80fd2e64

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Varinder Sandhu Mr or Mrs. 500 Points: 559 More actions · Answer 2

Please see this URL

http://the-it-articles.blogspot.com/2010/12/partner-transaction-manager-has.html

Varinder Sandhu,
http://www.varindersandhu.in/

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

Varinder Sandhu (12/26/2010)

Please see this URL

http://the-it-articles.blogspot.com/2010/12/partner-transaction-manager-has.html%5B/quote%5D

So you ripped of a post on MSDN from a person who solved his own problem, so you could post it on your own blog, then go to a forum (this one) to post a link to your blog? While actually the problem in this thread has already been solved a year and a half ago by Phil posting an URL to the original MSDN forum post?

:rolleyes: (--> this smiley is rolling with his eyes. It isn't always very clear.)

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

dndaughtery SSChampion Points: 11290 More actions · Answer 4

Hey guys, I followed the instructions but when I click the MSDTC tab I dont see a link for "Security Configuration". Am I doing something wrong?

dndaughtery SSChampion Points: 11290 More actions · Answer 5

I followed the steps in the following link and set the properties as seen on the page there. I'm still getting the "The partner transaction manager has disabled its support for remote/network transactions." error when running the package from my laptop. I have the same settings on my laptop. I also get an error when I run the package on the server from an SQL Job.

http://blog.arjanfraaij.com/2010/11/enabling-distributed-transaction.html

dndaughtery SSChampion Points: 11290 More actions · Answer 6

Ok, I went back and followed all of the instructions including enableing the DTC TCP rules for the firewall for both servers as well as my laptop and now getting the following error:

The transaction has already been implicitly or explicitly committed or aborted

dugsmith Mr or Mrs. 500 Points: 597 More actions · Answer 7

The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D025 “The partner transaction manager has disabled its support for remote/network transactions.”.

Solution: Click the dataflow task–>properties–> change the transaction option to “supported” this will solve the issue.

dugsmith Mr or Mrs. 500 Points: 597 More actions · Answer 8