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


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 Transaction Coordinator) to execute distributed transactions for SQL Server containers running on a Kubernetes platform.

 

Please see the following documentation for more information on DTC and SQL Server on Linux. How to configure MSDTC on Linux – SQL Server | Microsoft Docs.

 

The first step is to set up a Kubernetes cluster and connect to it. As usual, I’ll be using