Introduction

This article describes the versions of Microsoft SQL Server that are supported when you use different versions of Microsoft BizTalk Server. It also describes 64-bit support for the different versions and editions of BizTalk Server.

List Microsoft SQL Server versions supported

Latest version of BizTalk Server

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

  BizTalk Server
2013 R2
SQL Server 7.0 No
SQL Server 2000 No
SQL Server 2000, 64-Bit Edition No
SQL Server 2005, including 64-bit  No
SQL Server 2008, including 64-bit No
SQL Server 2008 R2, including 64-bit No
SQL Server 2012, including 64-bit No
SQL Server 2012 SP1, including 64-bit Yes
SQL Server 2014, including 64-bit Yes


SQL Server Desktop Engine SQL Server Express Edition is supported, but is not recommended

From BizTalk Server 2006 R2 to BizTalk Server 2013

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

  BizTalk Server
2006 R2
BizTalk Server
2009
BizTalk Server
2010
BizTalk Server
2013
SQL Server 7.0 No
No
No
No
SQL Server 2000 Yes, with SQL Server 2000 Service Pack 4 No No
No
SQL Server 2000, 64-Bit Edition Yes
No
No
No
SQL Server 2005, including 64-bit  Yes
Yes, with SQL Server 2005 Service Pack 2 or later service pack
No
No
SQL Server 2008, including 64-bit No
Yes Yes, with SQL Server 2008 Service Pack 1 or later service pack  No
SQL Server 2008 R2, including 64-bit No
No
Yes
Yes, with SQL Server 2008 R2 Service Pack 1 or later service pack
SQL Server 2012, including 64-bit No
No
No
Yes
SQL Server 2012 SP1, including 64-bit No
No
No
No
SQL Server 2014, including 64-bit
No
No No
No
         
SQL Server Desktop Engine SQL Server Express 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 SQL Server Express Edition is supported, but is not recommended

From BizTalk Server 2000 to BizTalk Server 2006

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

  BizTalk Server
2000
BizTalk Server
2002
BizTalk Server
2004
BizTalk Server
2006
SQL Server 7.0 Yes Yes, with SQL Server 7.0 Service Pack 3 or later service pack 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
SQL Server 2000, 64-Bit Edition No No
Yes, if the computer that is running SQL Server is remote
Yes
SQL Server 2005, including 64-bit  No No No
Yes
SQL Server 2008, including 64-bit No No No
No
SQL Server 2008 R2, including 64-bit No No No No
SQL Server 2012, including 64-bit No No No
No
SQL Server 2012 SP1, including 64-bit No No No
No
SQL Server 2012, including 64-bit 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

See Also

Related articles or references:

Another important place to find a huge amount of BizTalk related articles is the TechNet Wiki itself. The best entry point is BizTalk Server Resources on the TechNet Wiki.