TransactionManagerCommunicationException using TransactionScope

[Guest]

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.

 

[Luke Zhang [MSFT]]

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

 

[jemkem]

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