Solved

Network access for Distributed Transaction Manager (MSDTC) has been disabled

Posted on 2009-04-04
6
2,861 Views
Last Modified: 2012-05-06
I'm getting the following error when trying to do a transaction to a remote server.

System.Transactions.TransactionManagerCommunicationException: 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 Ad...

I've tried numerous things to resolve this problem with no luck.

Here is the scenario:
I have a windows application that is running from either Windows XP SP2, Windows Vista 64, or Windows 2003 Server (all get the same error message).
The application connects to a SQL 2005 Server running on a remote W2K3 SP1 server.
MSDTC is running on both the client AND the server (so the error message is useless as it MSDTC service is IN FACT running).
Both client and server allow both incoming and outgoing connections.
Firewalls have been disabled on both Client and Server.
I set up authentication to NONE on both client and server.
Same error...
The application works fine on a local computer with a local database (and the transactions work wonderfully)

I'm stumped on this one.
I've attached a couple of server settings screenshots for clarity.



Settings1.jpg
Settings2.jpg
0
Comment
Question by:bd9000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 38

Expert Comment

by:Jim P.
ID: 24073038
Make sure that the COM Security is set to everyone and anonymous login.


COM-Security.jpg
0
 

Author Comment

by:bd9000
ID: 24073277
on the client or the server?
0
 

Author Comment

by:bd9000
ID: 24073323
I uninstalled and reinstalled MSDTC on both the server and client and rebooted twice each.
I get the new message:

system.transactions.transactionpromotionException: Failure while attempting to promote transaction -->

Is there any step-by-step instructions out there that show how to get MSDTC to ACTUALLY work between a REMOTE server and a client - the most common situation for 10million+ Windows developers?
Microsoft's help is useless.  Keeping systems wide-open and vulnerable seems to defeat MS's intent on securing Windows without tellings us how to disable all the "security" patches so we can get actual work done!
0
Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

 
LVL 38

Expert Comment

by:Jim P.
ID: 24073705
Basically M$ has abandoned DCOM & DTC in favor of the .NET versions of the same crap. My experience with it has been the minimal of getting a specific vendor app working in our environment. If you ending up understanding it, "You're a better man than I am, Gunga Din!".

Chapter 11  Building Secure Serviced Components
http://msdn.microsoft.com/en-us/library/aa302427.aspx

SAMPLE: A Simple DCOM Client Server Test Application
http://support.microsoft.com/kb/259011/

How to configure COM Internet Services (CIS) on the client side
http://support.microsoft.com/kb/265340
0
 

Accepted Solution

by:
bd9000 earned 0 total points
ID: 24074234
I'm using DotNet 3.5 SP1,  ADO.NET still uses DCOM, apparently wrapped up inside managed code (thus making it unmanaged again -sigh!).  

The app is entirely managed code, written in VS2008 - works fine on a LAN - fails when one of the SQL Servers in the transaction is off-site.

This code worked fine just a year ago (on DotNet3.5) running on W2K3 (no SP) and XP SP2.

What joke!  Oracle, here we come!
0
 

Author Comment

by:bd9000
ID: 24123086
Here's the real answer to this problem.
 It can't be done without a VPN.   REPEAT, you MUST have a VPN or a STATIC IP ADDRESS!
MSDTC can't work at all over the Internet without a VPN tunnel and will never work with NAT routers (as per Microsoft).
I can't figure what the "D" in DTC stands for, certainly not "Distributed"! :)
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
WARNING:   If you follow the instructions here, you will wipe out your VTP and VLAN configurations.  Make sure you have backed up your switch!!! I recently had some issues with a few low-end Cisco routers (RV325) and I opened a case with Cisco TA…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question