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:
- Make sure that the Microsoft Distributed Transaction Coordinator (MSDTC) is running
- Change the security on the SQL Server database so that it allows distributed transactions on both the web/application server and the database server.
- Ensure that Windows Firewall allows the MSDTC to communicate between the two servers.
For more details on the issue, please refer to: