using a single transaction scope to have db queries across 2 different db servers

Question

using a single transaction scope to have db queries across 2 different db servers

I am using transaction scope. I want to have a transaction scope for 2 queries that are run in different database servers. One query runs on one server and the other one runs in a different server.

However a single query will have its own transaction scope as it is to work with multiple tables.

I am getting the following excpetion

The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)

Any suggestions on how to tackle this issue?

msdtc

asked on Stack Overflow May 6, 2011 by

Saravanan

2 Answers

On remote hosts (DB servers in that case):

From Control Panel, open Administrative Tools, and then open Component Services.
Expand Component Services, right-click My Computer, and then select Properties.
Click the MSDTC tab, and then click Security Configuration.
Tick anything under "network DTC access".

Check that the firewalls don't block MSDTC as well on clients and servers.

answered on Stack Overflow May 6, 2011 by

Johann Blais

As mentioned in the first answer MSDTC must be enabled on both client and server machines. However, in addition there may be some extra configuration required especially if firewalls are involved. The following link: MSDTC Troubleshooting describes many of the possible errors that may occur, how to fix them and some useful tools for debugging such as DTCTester and DTCPing.