How to Configure for TransactionScope

William posted on Wednesday, August 30, 2006

I am using TransactionalTypes.TransactionScope for my DataPortal_XXX methods.

My business objects and Data Portal run on the same web server and access SQL Server database on another machine. What I attempt to save the object, which involves distributed transaction, it throws me the following error.

Csla.DataPortalException : DataPortal.Update failed
Csla.Server.CallMethodException : DataPortal_Insert method call failed
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 Administrative tool.
System.Runtime.InteropServices.COMException : The transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D024)

How should I configure the server or MSDTC to resolve this?

Regards,
William

 

RockfordLhotka replied on Wednesday, August 30, 2006

There's a Microsoft article on this. The issue appeared with XP SP2, because they tightened security and turned off the DTC by default.

William replied on Wednesday, August 30, 2006

Thanks Rocky. I will try out the configuration outlined in the MS article.

Regards,
William

 

Jasmeet replied on Thursday, January 25, 2007

Hi Rocky,

I have recently started using your framework and am still learning my way around.

I am also using TransactionScope but both my application and the SQL server reside on the same machine.

I have a parent object with a collection of child objects. In the INSERT on the parent - the sql connection works fine but as soon as it goes to the child update and tries to open a connection, I get the same error as above.

Need some help as to figure out where I am going wrong.

Thanks

Jas

ajj3085 replied on Thursday, January 25, 2007

Change the code so that only one connection is opened.

As soon as you open a second connection, even if you use the same connection string, TS promotes the transaction to a distributed transaction.

Jasmeet replied on Thursday, January 25, 2007

Thanks !

Had tried that and it worked. Your reply just confirmed that I did right. ~smile~

 

Jas

skaue replied on Wednesday, February 06, 2008

RockfordLhotka:

There's a Microsoft article on this. The issue appeared with XP SP2, because they tightened security and turned off the DTC by default.

Article is gone. Any idea where too?

Bowman74 replied on Wednesday, February 06, 2008

skaue:

Article is gone. Any idea where too?

If you google the DTCTest and DTCPing tools you should be able to get what you need.

Thanks,

Kevin

andrewem replied on Friday, May 09, 2008

Has anyone found a solution to this problem?

I too am getting the exception:

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 have looked on the Internet and at the article above, nothing is working. I am using a local client Windows XP SP2 connecting across the network to a SQL 2005 database on a Windows 2003 server (standard edition).

Appreciated.

A

sergeyb replied on Friday, May 09, 2008

smiley riley replied on Monday, May 12, 2008

Try looking up enabling XA transactions or network DTC transactions one of those anyway.

Ensure MSDTC is running

 

this is a guess. Admin Tools>Component Services>My Computer/properties>MSDTC(Tab)

its there somewhere.Probably best to search rather than guess tho.

Paul

 

PS Ensure the remote computer is setup as well. People tend to forget that one.