Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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:
- Summary of SQL Server versions supported by BizTalk Server
- Summary of 64-bit support, operating systems and SQL Server versions supported by BizTalk Server
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.