janvier 11, 2018  

Read This Before Implementing AlwaysOn for BizTalk Server 2016

Biztalk 2016 consideration of MSDTC between databases on the same SQL instance

Kjetil Tonstad Integration Blog

One of the major news in BizTalk Server 2016 is the full support for SQL AlwaysOn Availability Groups (AGs). When Microsoft announced this, the crowd cheered, and they moved on to the next slide. There are, however, some bits you should be aware of before deciding on your High Availability (HA) architecture for BizTalk.

The Background
SQL Server 2016 is the first (and only) edition to support AlwaysOn for BizTalk Server 2016. The reason is lack of support for MSDTC between BizTalk’s SQL Server databases and other transactional resources. For this reason, High Availability for the database layer in BizTalk scenarios has traditionally been solved by using Windows Server Failover Clusters (WSFC), typically with an active-passive configuration.

The Requirements
First of all, you need to run BizTalk Server 2016 Enterprise, SQL Server 2016 Enterprise, and Windows Server 2016 (or 2012 R2 with KB3090973).

As you may be aware of…

Voir l’article original 450 mots de plus

À propos de hichamveo

I am a Microsoft certified solution developer with more than 10 years of I.T. experience working in different industry sectors(Group Life Insurance, Retail, E-Learning, E-Commerce,Infrastructure & Urban Development ) on projects ranging from small bespoke applications to multi-million Euros enterprise solutions. I am proactive in learning new technologies and like to take the responsibilities in work as it comes. Currently focused on Microsoft Integration technologies, especially BizTalk server, .NET solutions and Windows Azure.

Laisser un commentaire