MSDTC on server 'xxxx' is unavailable

Symptoms

"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.

Cause

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

Resolution

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.

References

Eigenschappen

Artikel-id: 962313 - Laatst bijgewerkt: 14 jan. 2009 - Revisie: 1

Feedback