LINQ - Handle Transactions - Asked By Shan on 04-May-11 06:57 AM

Hi,

 If I use

using (tScope = new System.Transactions.TransactionScope())

{

}

1st record gets inserted and I get

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.

From the error message you provided, the cause of the problem is that Distributed Transaction Manager has been disabled on your machine.

Could you please make sure that if the MSDTC service has been started?  Following the steps below:

 1.Open your control panel, click on Administrative Tools.

2.Click on Component Service, expand the component service node, and then expand the Computers child node.

3.Right click on My Computer, choose “Properties”, and check if the MSDTC works.

Hope that helps. 

You need to enable network DTC access as described in this Microsoft TechNet Article. This change may have to be made on both the database and application servers. Often times DTC is already turned on a database server so I'd look at the application server first.

Here is a screen shot of what we use except for "Allow Remote Administration"