MSDTC Error: when trying to use multiple transactions over networks

Question

_{Friday, February 22, 2013 9:43 AM}

Hi,

i have some problems related to MSDTC and i don't know how to fix it yet, hope you all can help me.

Locally, i used windows 7 with SQL Server 2008R2 and VS2008, with this i can use MSDTC without any error. But when i deploy it into the server:

I have two servers, IIS server which run on Windows Server 2008R2 and Database server which run on Windows Server 2003R2 and have SQL Server 2008R2 the same as my Windows 7, and i got an error like below:

The transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D024)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: The transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D024)

Note: I already enable the MSDTC server on Database server which have the option below:

Network DTC Access: Check

On Transaction Manager Communication

Mutual Authentication Required(Choosen)

However, it still not works, What is the problems is? Please kindly helps me for a solutions.

Thank you very much...!

All replies (2)

_{Friday, February 22, 2013 11:05 AM ✅Answered | 1 vote}

Hi Jeffreedoo

please check this link.

The partner transaction manager has disabled its support for remote/network transactions

_{Saturday, February 23, 2013 4:04 AM}

Dear kyk_nk,

I'm really appreciate for this solutions.

Thank you so much...!