Blog Post

SQL Server Blog
5 MIN READ

Configure MSDTC to run Distributed transactions for SQL Server Linux Containers on Azure Kubernetes

amvin87's avatar
amvin87
Icon for Microsoft rankMicrosoft
Mar 17, 2022
It's been a while since I've had the opportunity to write and share a blog post about SQL Server containers and Linux. Today, I'd like to show you how to set up and use MSDTC (Microsoft Distributed T...
Updated Mar 17, 2022
Version 2.0
SQLServerTiger
Dhaval_Mehta's avatar
Dhaval_Mehta
Copper Contributor
May 10, 2022

Hi Amit,

 

I tried .Net framework client app in the same AKS cluster but getting error for MSDTC transaction. 

In Single AKS, Windows container on windows 2019 node with .Net framework app using new TransactionScope() library and trying to us  SQL deployed in linux node. It tries to update two tables into two different databases in Linux SQL container, in single TransactionScope() .

 

Error is

Getting below error when accessing database communication with the underlying transaction manager has failed. The MSDTC transaction manager was unable to pull the transaction from the source transaction manager due to communication problems. Possible causes are: a firewall is present and it doesn't have an exception for the MSDTC process, the two machines cannot find each other by their NetBIOS names, or the support for network transactions is not enabled for one of the two transaction managers.

 

Appreciate if you can your input on above use case

Many .net framework legacy apps are using TransactionScope. Use case is migrate them to AKS windows container and use SQL MSDTC without any code changes.