none
AOAG with two sql nodes in different subnets RRS feed

  • Question

  • I have Sql server 2016 Ent and BizTalk 2016 Ent.

    I would like to know if you can install biztalk with just two sql nodes in different subnets.  The documentation shows 9 nodes in what i assume is a sample configuration.

    I have configured the SQL nodes however, Biztalk configuration fails.


    Thursday, July 5, 2018 7:01 AM

All replies

  • Hi,

    If you have setup MultiSubnetFailOvercluster then BizTalk server is not supporting the same (refer the Link#1 for details).

    If you have configured AOAG then follow steps mentioned in below article with title 

    Configure BizTalk when Availability Groups are already set up

    https://docs.microsoft.com/en-us/biztalk/core/high-availability-using-sql-server-always-on-availability-groups#configure-biztalk-when-availability-groups-are-already-set-up

    else Move existing BizTalk databases to Availability Groups

    https://docs.microsoft.com/en-us/biztalk/core/high-availability-using-sql-server-always-on-availability-groups#move-existing-biztalk-databases-to-availability-groups


    Also advised you to visit the Microsoft Trained Engineer LAB (refer Link#2) if you plan to reconfigure from scratch



    Link#1 https://docs.microsoft.com/en-us/biztalk/core/high-availability-using-sql-server-always-on-availability-groups

    Link#2 https://skastberg.wordpress.com/2017/02/22/setting-up-my-biztalk-server-2016-using-availability-groups-lab/

    Hope this Helps!!!!

    Regards,


    Note: Please Mark As Answered if you satisfy with Reply.
    Thursday, July 5, 2018 8:11 AM
  • Here's the deal.  So long as the SQL Server computers are OK with different subnets, BizTalk doesn't care and really isn't even aware.

    But, probably you should not use AOAG.  AOAG is great, but not for BizTalk Server as there is no incremental benefit to BizTalk that justifies the extra complexity of AOAG on SQL Server.

    BizTalk Server was designed with regular old, but proven and very reliable, Windows Failover Clustering in mind.


    Thursday, July 5, 2018 1:37 PM
    Moderator
  • For AOAG;

    Provide high availability for BizTalk databases using AlwaysOn Availability Groups

    In the basic configuration of BizTalk Server, a minimum of 9 databases are created including Rules and BAM databases. Due to the MSDTC limitation with Availability Groups mentioned previously, a configuration such as following does not ensure transactional consistency i.e. all DB servers on the same node. I think you should read the official documentation for AOAG

    https://docs.microsoft.com/en-us/biztalk/core/high-availability-using-sql-server-always-on-availability-groups#configure-biztalk-when-availability-groups-are-already-set-up

    On the other hand; as John mentioned, AOAG, in general, is not a great choice for the reasons which are covered in this link; https://www.art2link.com/biztalk-2016-sql-server-2016-alwayson/


    Thursday, July 5, 2018 5:01 PM