Asked by:
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.
- Biz1
- 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 AMModerator -
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 AMModerator -
Thanks brother
Monday, April 17, 2017 8:54 AM -
Thanks brotherMonday, April 17, 2017 8:54 AM
-
Thanks brotherMonday, April 17, 2017 8:54 AM
-
What exactly are these 'resource limitations'? Maybe we can help address those.Monday, April 17, 2017 1:41 PMModerator