MSDTC and Distributed Computing

Question

while there are various articles on MSDTC, I can't seem to find some detailed explaination of MSDTC to figure out how I need to configure it for my particular scenario.

Here is my scenario. I have a few WCF services that are running on box A, a SQL-Server running on box B, and a test solution on box C. In my tests (Box C) I'm pretty much calling a few services (box B), doing some work that eventually writes to a database. When I run these tests using the SQL database on the same box as the tests (Box C), everything works great, and everybody is happy. However, once I just change the test solution to point to the SQL-server database on box-B, I get the exception:

Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool.

One of the questions that I have is I don't have MSDTC enabled on the test box (Box C) so why isn't this exception being thrown when I run tests here with the database locally here? And if I need to enable MSDTC, do I need to enable it for all three boxes (A-B-C)?

Thanks!

Cliffboss · Accepted Answer · 2011-08-16 17:04:12Z

2

MSDTC is enabled by default, but the network access is disabled.

So when you have cross machine talking it fails.

You will need to enable network. See this article.

http://technet.microsoft.com/en-us/library/cc753510%28WS.10%29.aspx

I had this same issue a week or so ago and it fixed it for me.

answered Aug 16, 2011 at 17:04

Cliffboss

1902 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

5StringRyan Over a year ago

I followed the page, and set everything listed for the SQL Box (Box B). I've also allowed DTC through the firewall, but now I get this exception: The MSDTC transaction manager was unable to pull the transaction from the source transaction manager due to communication problems. Possible causes are: a firewall is present and it doesn't have an exception for the MSDTC process, the two machines cannot find each other by their NetBIOS names, or the support for network transactions is not enabled for one of the two transaction managers.

5StringRyan Over a year ago

I've enabled MSDTC on all, as well as poked holes in the firewall for all. One update that I forgot to mention, the service and sql boxes (A and B) are on the same domain, while the testing box (box C) is on another.

Cliffboss Over a year ago

hrmm, not quite sure then sorry.

Collectives™ on Stack Overflow

MSDTC and Distributed Computing

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related