If you are running SpiraPlan, SpiraTest or SpiraTeam v4.1 or later and you have the following message in the error logs:

The underlying provider failed on Open. [System.Data.EntityException]
   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.Transactions.TransactionManagerCommunicationException]
   The transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D024) [System.Runtime.InteropServices.COMException

It means that you need to do the following:

  1. Make sure that the Microsoft Distributed Transaction Coordinator (MSDTC) is running
  2. Change the security on the SQL Server database so that it allows distributed transactions on both the web/application server and the database server.
  3. Ensure that Windows Firewall allows the MSDTC to communicate between the two servers.

For more details on the issue, please refer to:

http://stackoverflow.com/questions/10130767/the-transaction-manager-has-disabled-its-support-for-remote-network-transactions

http://technet.microsoft.com/sv-se/library/cc753620%28v=ws.10%29.aspx

http://technet.microsoft.com/sv-se/library/cc725913%28v=ws.10%29.aspx