If you are running Spira v4.1 and you have the situation where you cannot create requirements or use case steps, please read this article for instructions on how to fix the issue.

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:





Article Info
  • Last Updated: 2/11/2014
  • Article ID: KB72
  • Views: 3167