CSLA .NET

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

 

---

Regards,
William

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

---

Rocky

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

Regards,
William

 

---

Regards,
William

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

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.

Thanks !

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

 

Jas

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?

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

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

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.