Summary of operating systems and SQL Server versions supported by different versions of BizTalk Server

View products that this article applies to.

This article describes the versions of Microsoft Windows and the versions of Microsoft SQL Server that are supported when you use different versions of Microsoft BizTalk Server.

MORE INFORMATION

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

Collapse this tableExpand this table

	Microsoft BizTalk Server 2000	Microsoft BizTalk Server 2002	Microsoft BizTalk Server 2004	Microsoft BizTalk Server 2006	Microsoft BizTalk Server 2006 R2	Microsoft BizTalk Server 2009
Microsoft Windows XP	No	Yes	Yes, with Windows XP Service Pack 1	Yes, with Windows XP Service Pack 2	Yes, with Windows XP Service Pack 2	Yes, with Windows XP Service Pack 3
Microsoft Windows 2000	Yes	Yes	Yes, with Windows 2000 Service Pack 4	Yes, with Windows 2000 Service Pack 4	No	No
Microsoft Windows Server 2003	No	Yes, with BizTalk Server 2002 Service Pack 1	Yes	Yes, with Windows Server 2003 Service Pack 1	Yes, with Windows Server 2003 Service Pack 1	Yes, with Windows Server 2003 Service Pack 1
Microsoft Windows XP Professional, 64-Bit Edition	No	No	No	Yes	Yes, with Windows XP Service Pack 2	Yes, with Windows XP Service Pack 3
Microsoft Windows Server 2003, 64-Bit Edition	No	No	No	Yes	Yes	Yes
Windows Vista	No	No	No	Yes	Yes	Yes, with Windows Vista Service Pack 1
Windows Vista, 64-Bit Edition	No	No	No	Yes	Yes	Yes, with Windows Vista Service Pack 1
Windows Server 2008	No	No	No	No	No	Yes
Windows Server 2008, 64-Bit Edition	No	No	No	No	No	Yes
Microsoft SQL Server 7.0	Yes	Yes, with SQL Server 7.0 Service Pack 3	No	No	No	No
Microsoft SQL Server 2000	Yes	Yes, with SQL Server 2000 Service Pack 2 or a later version	Yes, with SQL Server 2000 Service Pack 3a or a later version	Yes, with SQL Server 2000 Service Pack 4	Yes, with SQL Server 2000 Service Pack 4	No
Microsoft SQL Server 2000, 64-Bit Edition	No	No	Yes, if the computer that is running SQL Server is remote	Yes	Yes	No
Microsoft SQL Server 2005	No	No	No	Yes	Yes	Yes, with SQL Server 2005 Service Pack 2
Microsoft SQL Server 2005, 64-Bit Edition	No	No	No	Yes	Yes	Yes, with SQL Server 2005 Service Pack 2
Microsoft SQL Server 2008	No	No	No	No	No	Yes
Microsoft SQL Server 2008, 64-Bit Edition	No	No	No	No	No	Yes
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

Note All editions of BizTalk Server 2006 and of later versions are supported on x64 operating systems. Only the Enterprise and Developer editions of BizTalk Server 2006 and of later versions are supported in native 64-bit execution. All editions of BizTalk Server 2004, of BizTalk Server 2002, and of BizTalk Server 2000 are supported on x64 operating systems but are not supported in native 64-bit execution.