Summary of SQL Server versions supported by BizTalk Server

Posted: October 7, 2011  |  Categories: Administration BizTalk
Tags: BizTalk Configuration Installation

The following table describes the versions of SQL Server that are supported when you use different versions of BizTalk Server:

BizTalk Server 2016 BizTalk Server 2013 R2 BizTalk Server 2013 BizTalk Server 2010 BizTalk Server 2009
SQL Server 2016 Yes No No No No
SQL Server 2014 Yes, with SQL Server 2014 Service Pack 1 Yes No No No
SQL Server 2012 No Yes, with SQL Server 2012 Service Pack 1 Yes No No
SQL Server 2008 R2, including 64-bit No No Yes, with SQL Server 2008 R2 Service Pack 1 or later service pack Yes No
SQL Server 2008, including 64-bit No No No Yes, with SQL Server 2008 Service Pack 1 or later service pack Yes
SQL Server 2005, including 64-bit No No No No Yes, with SQL Server 2005 Service Pack 2 or later service pack
SQL Server 2000, 64-Bit Edition No No No No No
SQL Server 2000 No No No No No

Older versions:

BizTalk Server 2000 BizTalk Server 2002 BizTalk Server 2004 BizTalk Server 2006 BizTalk Server 2006 R2
SQL Server 7.0 Yes Yes, with SQL Server 7.0 Service Pack 3 or later service pack No No No
SQL Server 2000 Yes Yes, with SQL Server 2000 Service Pack 2 or later service pack Yes, with SQL Server 2000 Service Pack 3a or later service pack Yes, with SQL Server 2000 Service Pack 4 Yes, with SQL Server 2000 Service Pack 4
SQL Server 2000, 64-Bit Edition No No Yes, if the computer that is running SQL Server is remote Yes Yes
SQL Server 2005, including 64-bit No No No Yes Yes
SQL Server 2008, including 64-bit No No No No No
SQL Server 2008 R2, including 64-bit No No No No No
SQL Server 2012, including 64-bit No No No No No
SQL Server 2012 R2, including 64-bit No No No No No
SQL Server Desktop Engine Yes Yes BizTalk Server 2004 Partner Edition is supported but is not recommended SQL Server Express Edition is supported but is not recommended SQL Server Express Edition is supported, but is not recommended

Original source from Microsoft Help and Support: http://support.microsoft.com/kb/926628

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

2 thoughts on “Summary of SQL Server versions supported by BizTalk Server”

    1. will you be able to provide an update to this table for BT2013R2 vs SQL2014 SP1, SP2, CUs for SP2 etc…would be very helpful

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

turbo360

Get integration tips every day. Follow us on:

Back to Top