MSDTC on server 'xxxx' is unavailable


"MSDTC on server 'xxxx' is unavailable"

This error occurs when trying to log on to a company in Management Reporter and the ManagementReporterReport database was installed to SQL Server 2000.


This error occurs when the Microsoft Distributed Transaction Service is not started on the server that hosts the ManagementReporterReport database.


To resolve this issue, do the following on the server where the ManagementReporterReport database resides:
  1. Open SQL Server Service manager (Start - All Programs - Microsoft SQL Server - Service Manager).
  2. Make sure that the correct server is selected in the Server list.
  3. Select Distributed Transaction Coordinator from the Services list.
  4. Click on Start/continue.