Solved

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

Posted on 2009-04-04
6
2,768 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
  • 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Give your grad a cloud of their own!

With up to 8TB of storage, give your favorite graduate their own personal cloud to centralize all their photos, videos and music in one safe place. They can save, sync and share all their stuff, and automatic photo backup helps free up space on their smartphone and tablet.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Restrict RDP Remote Access through SonicWall 3 97
Need help debbuging stored procedure 21 35
ssh setup on Cisco swith 11 46
SOFS cluser offline 3 44
Even if you have implemented a Mobile Device Management solution company wide, it is a good idea to make sure you are taking into account all of the major risks to your electronic protected health information (ePHI).
In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
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…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now