MSDTC - Distributed Transaction Coordinator service is not available after configuring SQL to be highly available.
Article ID: 100023033
Updated On:
Description
Error Message
Distributed Transaction Coordinator service is unavailable
Resolution
To resolve this, simply create a Service Group in the cluster for MSDTC, using a designated Lanman resource with a unique Virtual Server Name.
This will allow the cluster to properly identify the MSDTC service and assign a Virtual Server Name appropriately.
Issue/Introduction
During the SQL installation and configuration for use with Storage Foundation for Windows with High Availability (SFW-HA), if the Microsoft Distributed Transaction Coordinator (MSDTC) has not been configured within the cluster with a separate Service Group, then this could result in the MSDTC service not starting properly, as it should be looking for a Virtual Server Name assigned from its own Lanman resource. Without that Lanman resource, the machine name is more than likely being used and therefore the service is inaccessible by the cluster.
Was this article helpful?
Yes
No
Powered by
