Azure SQL Managed Instance XA Transactions

Pim Beliën 1 Reputation point
2021-02-25T14:56:29.13+00:00

Hi All,

Are XA transactions (so not MSDTC) on Managed Instance fully supported now? Or is it advised to use MS SQL Server on VM.
If it is, do I enable it the same way as I do on SQL Server?

Azure SQL Database

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Navtej Singh Saini 4,216 Reputation points Microsoft Employee
    2021-02-28T00:30:55.847+00:00

    @Pim Beliën -

    Managed Instance does not support XA transactions. On Azure SQL VMs one can use XA the same way as on SQL Server on-prem. Please visit the Azure Feedback page here to provide feedback and upvote the feedback here (1, 2)

    Please get back to us for more information.

    Regards
    Navtej S

  2. navid 1 Reputation point
    2022-04-27T08:48:04.483+00:00

    Interested in this feature as well, any roadmap updates as of today?

    0 comments