SSIS OlEDB Connection manager Error

3

When am using sequence container to roll back my transactions in execute sql task i am getting the error Connection manager Error: 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.". have set the transaction property to "Required" for Sequence container and inside all dataflow , execute sql tasks. i am using two sql servers one is source other is target in the network. please help

sql
sql-server
sql-server-2005
ssis
asked on Stack Overflow Feb 2, 2010 by rmdussa • edited Feb 3, 2010 by rmdussa

2 Answers

3

You can find it by using the command dcomcnfg on the Run window. Next, Expand all nodes under Component Services, and then you will see Distributed Transaction Cordinator. After that, Right Click to open Properties window, then go to Security tab to enable Inbound/ Outbound messages.

answered on Stack Overflow Mar 19, 2011 by Toan Nguyen
1

You have to enable "Remote/Network Transactions" in the DTS Service located in the sql server server.

Administrative Tools. Component Services

Computers / MyComputer / Properties / MSDTC / Security Configuration / Network DTC Access / Allow Remote Clients - Allow Inbound

answered on Stack Overflow Feb 5, 2010 by Burnsys • edited Feb 8, 2010 by Burnsys

User contributions licensed under CC BY-SA 3.0