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

Answer 1

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.

Answer 2

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

Answer 3

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

Answer 4

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

Answer 5

Thanks brother

Answer 6

Thanks brother

Answer 7

Thanks brother

Answer 8

What exactly are these 'resource limitations'?  Maybe we can help address those.