none
Setting Up BizTalk Server cluster and SQL Server cluster on same servers

    Question

  • Dear Experts,

    I want to setup BizTalk Server cluster environment. Due to resources limitation there is requirement to have Same nodes for SQL Server cluster and BizTalk Server.

    We have 2 servers e.g.

    1.        Biz1
    2.        Biz2

    Can we make Biz1 and Biz2 as 2 nodes for SQL server cluster for BizTalk server and at the same time both servers Biz1 and Biz2 used as nodes for BizTalk Server cluster.

    -Muhammad Masood

    Sunday, April 16, 2017 6:32 AM

All replies

  • Hi,

    Are you planing to setup a Windows Failover Cluster Instance or using Always On Availability Groups SQL Server 2016 ?

    Have have a look at my video tutorial about 

    BizTalk Server 2016 High Availability with AlwaysOn Availability Groups SQL Server 2016, part 1

    Yes, this works as both sql instances as well as BizTalk Server hosts are considered as cluster resources to the cluster service.

    See more here: Configuration of BizTalk Server hosts for Clustering

    hth

    Paul Endras |  ENDRAS IT CONSULTING

    If this answers your question and is a helpful post, please click Vote As Helpful, Propose As Answer, and/orMark As Answer.




    • Edited by Paul Endras Sunday, April 16, 2017 6:59 AM added more info
    Sunday, April 16, 2017 6:45 AM
  • Hi ,

    IF this a production environment, it is a big No NO, have seperate servers for the configurations,

    Depends also upon how you want your sql cluster, in active-passive mode and also about your Biztalk app server configurations,

    but for Prod environment, it is not recommended at all


    Mandar Dharmadhikari

    Sunday, April 16, 2017 7:48 AM
    Moderator
  • Please be aware having both BizTalk and SQL server on the same server can lead to bottlenecks and it is not recommended for production enviroments with high message load

    rgds /Peter

    Sunday, April 16, 2017 7:51 AM
  • As already mentioned here, having BizTalk Server and SQL Server sharing the same boxes in production is not at all wise.

    Also, note that clustering of the BizTalk Servers is not necessary unless you are  trying to create a Highly Available Receive Host for Receive Adapters such as POP3, MSMQ etc. (which cannot be run off multiple Receive Host Servers).



    Thanks Arindam

    Monday, April 17, 2017 1:06 AM
    Moderator
  • Thanks brother

    Monday, April 17, 2017 8:54 AM
  • Thanks brother
    Monday, April 17, 2017 8:54 AM
  • Thanks brother
    Monday, April 17, 2017 8:54 AM
  • What exactly are these 'resource limitations'?  Maybe we can help address those.
    Monday, April 17, 2017 1:41 PM
    Moderator