I'm writing a Windows service that uses the new TableAdapter in .NET 2.0. I
have several adapters that must be updated as an atomic operation, so I have
wrapped them using the TransactionScope.

When I run my code I get a TransactionManagerCommunicationException with the
following message "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."

I looked at the server and found a security configuration dialog for MSDTC.
When looking at the settings, "Network DTC Access' was enabled. I even tried
"No Authentication Required" without any luck.

I'm running SQL2005 on 2003 Server.

Hello,

You may open Control Panel\Administrative Tools\Component Services. Select
Component Services\Computer\My Computer, right-click and choose Properties.
On the MSDTC tab, press "Security Configuration..." and check if following
options are  enabled

Network DTC Access

Under Client and Administration
Allow Remote Clients
Allow Remote Administration

Under Transaction Manager Communication
Allow Inbound
Allow Outbound
No Authentication Required
Enale XA Transactions

And then reboot your computer and test again.

Luke

I've followed the instructions as described, but I still get the MSDTC
error when I attempt to deploy.  Any other suggestions?

SqlTransaction problems
click event handler executed twice
What causes SqlCommandBuilder to not build commands?
TransactionScope and DataSets
Table name in Dataset
SQL Table to DataSet to Dataview, to DataSet to XML!
DataSet to Dataview to Dataset to XML!
Fitting TableAdapter into Remoting Infrastructure
General network error
cannot connect to an oracle