Error Message: MSDTC on server 'XXXXXXXXXXXX--X' is unavailable

Question

Hello,

We have an Azure SQL data warehouse & Azure SQL database where we have started receiving the below error while executing StoredProcedures :

**Execution fail against sql server. Please contact SQL Server team if you need further support. Sql error number: 8501. Error Message: MSDTC on server 'XXXXXXXXXXXX--X' is unavailable
**
There were no issues before & there has been no deployment on the databases in last few hours.
Can someone help us understand the issue here & help us to resolve it ?

Thanks

Answer 1

Hi R-5499 •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, Azure SQL database goes into error while executing StoredProcedures.

If the service was stopped. solution: need to turn the MSDTC service on

1. go to Services. (START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > SERVICES)
2. Find the service called 'Distributed Transaction Coordinator' and RIGHT CLICK (on it and select) > Start.
3. make this service to run Automatically for solving this issue permanently.

In case you had a recent windows update, follow steps below if Distributed Transaction Coordinator stops running:

Launch Component Services (dcomcnfg.exe), then expand Component Services > Computers > My Computer, from here click on 'COM+ Applications' to see if an error will pop-up with "COM+ unable to talk to Microsoft Distributed Transaction Coordinator" or there will be a red error over the icon for My Computer in the navigation.

Refer: https://answers.microsoft.com/en-us/windows/forum/all/error-8004e00f-when-trying-to-access-com/782e5a36-d28f-4b35-a53c-f343e456638d

Let us know if above helps. If not, we will continue to investigate. Thanks