Summary of SQL Server versions supported by BizTalk Server

Posted: October 7, 2011 in BizTalk
Tags: , ,

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

 

BizTalk Server 2000

BizTalk Server 2002

BizTalk Server 2004

BizTalk Server 2006

BizTalk Server 2006 R2

BizTalk Server 2009

BizTalk Server 2010

BizTalk Server 2013

SQL Server 7.0

Yes

Yes, with SQL Server 7.0 Service Pack 3 or later service pack

No

No

No

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

No

No

No

SQL Server 2000, 64-Bit Edition

No

No

Yes, if the computer that is running SQL Server is remote

Yes

Yes

No

No

No

SQL Server 2005, including 64-bit

No

No

No

Yes

Yes

Yes, with SQL Server 2005 Service Pack 2 or later service pack

No

No

SQL Server 2008, including 64-bit

No

No

No

No

No

Yes

Yes, with SQL Server 2008 Service Pack 1 or later service pack

No

SQL Server 2008 R2, including 64-bit

No

No

No

No

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 No No No No Yes
SQL Server 2012 R2, including 64-bit No No No 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

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

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

Tags: BizTalk | Installation | Configuration

Comments
  1. These tables of yours are nicely done!

    • Anonymous says:

      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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s