?
Solved

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

Posted on 2009-04-04
6
Medium Priority
?
2,890 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

For many of us, the  holiday season kindles the natural urge to give back to our friends, family members and communities. While it's easy for friends to notice the impact of such deeds, understanding the contributions of businesses and enterprises i…
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…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Suggested Courses

762 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