locked
BizTalk 2016 support for SQL 2016 AlwaysOn feature RRS feed

  • Question

  • Hi,

    I would like to evaluate or test BizTalk 2016 CTP2 support for SQL 2016 AlwaysOn feature.

    I have a question regarding support for SQL Server 2016 AlwaysOn availability group from BizTalk 2016.Is it mandatory that, SQL server 2016 should be installed on Windows 2016?

    Your response will be highly appreciated.

    Regards

    Biranchi

    Tuesday, August 9, 2016 10:42 AM

Answers

  • Hi,

    No :) SQL Server 2016 supports MSDTC with AlwaysOn Availability Groups (AG) on Windows Server 2016 and Windows Server 2012 R2. Windows Server 2012 R2 requires the #3090973 Windows hotfix to be installed. SQL Server itself does not support MSDTC with AlwaysOn AG for any versions prior to 2016.


    Best regards, Kjetil :) Please remember to click "Mark as Answer" on the post that helps you. This can be beneficial to other community members reading the thread.

    My blog


    Tuesday, August 9, 2016 10:47 AM

All replies

  • Hi,

    No :) SQL Server 2016 supports MSDTC with AlwaysOn Availability Groups (AG) on Windows Server 2016 and Windows Server 2012 R2. Windows Server 2012 R2 requires the #3090973 Windows hotfix to be installed. SQL Server itself does not support MSDTC with AlwaysOn AG for any versions prior to 2016.


    Best regards, Kjetil :) Please remember to click "Mark as Answer" on the post that helps you. This can be beneficial to other community members reading the thread.

    My blog


    Tuesday, August 9, 2016 10:47 AM
  • Hi,

    The following table shows the operating system requirements for the principal editions of SQL Server 2016:

    https://msdn.microsoft.com/en-us/library/ms143506.aspx#hwswr

    SQL Server Edition Supported Operating System
    SQL Server Enterprise Windows Server 2012 R2 Datacenter

     Windows Server 2012 R2 Standard

     Windows Server 2012 R2 Essentials

     Windows Server 2012 R2 Foundation

     Windows Server 2012 Datacenter

     Windows Server 2012 Standard

     Windows Server 2012 Essentials

     Windows Server 2012 Foundation
    SQL Server Standard Windows Server 2012 R2 Datacenter

     Windows Server 2012 R2 Standard

     Windows Server 2012 R2 Essentials

     Windows Server 2012 R2 Foundation

     Windows Server 2012 Datacenter

     Windows Server 2012 Standard

     Windows Server 2012 Essentials

     Windows Server 2012 Foundation

    Windows 10 Home

    Windows 10 Professional

    Windows 10 Enterprise

     Windows 8.1

     Windows 8.1 Pro

     Windows 8.1 Enterprise

     Windows 8

     Windows 8 Pro

     Windows 8 Enterprise
    SQL Server Web Windows Server 2012 R2 Datacenter

     Windows Server 2012 R2 Standard

     Windows Server 2012 R2 Essentials

     Windows Server 2012 R2 Foundation

     Windows Server 2012 Datacenter

     Windows Server 2012 Standard

     Windows Server 2012 Essentials

     Windows Server 2012 Foundation

    These are the version of SQL server supported for BizTalk 2016.

    Data Integration

    Data integration clients and DRDA Service support the following SQL Server versions:

    • SQL Server 2016

    • SQL Server 2014

    • SQL Server 2012

    Please check this msdn article.

    https://msdn.microsoft.com/en-us/library/mt748660.aspx


    Regards Pushpendra K Singh


    Tuesday, August 9, 2016 1:48 PM
  • Thanks a lot for your reply.

    Regards

    Biranchi

    Wednesday, August 10, 2016 3:36 AM