Good morning all

I am working on a Biztalk migration project On an alwayson SQL environment

Who has an idea if BIztalk is compatible with ALWAYSON if YES it is from Which version?

another question for the activation of the MSDTSC function should you activate this option in Always on

thank you for your help

enter image description here

  • 2
    Have you read the docs yet?
    – vonPryz
    Nov 13 '20 at 17:20

Biztalk is compatible with ALWAYS ON from SQL Sever 2016: https://docs.microsoft.com/en-us/biztalk/core/high-availability-using-sql-server-always-on-availability-groups

You have here a brief introduction and a setup of Microsoft Distributed Transaction (MS DTS). Microsoft says that is available starting from SQL Server 2016 Service Pack 2.

I found a link that is talking about best practice and is mentioning Biztalk which is exaclty your scenario but.... it doesn't give any example about how to setup MS DTS with Bitztalk.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.