MSDTC on Azure

Question

MSDTC on Azure

EifelYeti 46

I would like to use a Iaas installation using Component Services. In Component Services I run different version of COM+ components in VB6, .NET 3.5 and .NET 4.7.1. That components are using MSDTC and create transactions on the SQL Server. Is it possible to create transactions using MSDTC in VB6 in Iaas and using a managed Azure SQL?

Accepted answer

0 additional answers

Your answer

Answer 1

Alberto Morillo 34,671 MVP Volunteer Moderator

MSDTC is fully supported on SQL Server IaaS (SQL Server on VMs).

However, MSDTC is partially supported on Azure Managed Instance as mentioned here. Read the following excerpt:

"Partial support for distributed transactions is currently in public preview. Distributed transactions are supported under following conditions (all of them must be met):

all transaction participants are Azure SQL Managed Instances that are part of the Server trust group.
transactions are initiated either from .NET (TransactionScope class) or Transact-SQL.
Azure SQL Managed Instance currently does not support other scenarios that are regularly supported by MSDTC on-premises or in Azure Virtual Machines."

GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-07-06T14:56:16.393+00:00

@EifelYeti We haven't heard back from you. Just wanted to check if you find the above reply useful. If yes, do click on the 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution.

Regards
Geetha
EifelYeti 46 Reputation points

2022-10-22T08:19:09.683+00:00

Azure SQL database can't be used if you want to use VB6 or older .NET frameworks. So in order to have a working MSDTC with older frameworks you have to install a IAAS MS SQL server.

Share via

MSDTC on Azure

0 additional answers

Your answer