posts - 0, comments - 1573, trackbacks - 0
<< Borders - the book store | Home | Stripping the time portion of a SQL DateTime - Which is faster? >>

This table shows the operating systems that run the server software for each 32-bit version of SQL Server 2005.

I have been given a task of updating our SQL Server Infrastructure from SQL 2000 to SQL 2005 and I found this table that I thought may be of use to a lot of people.  If you are running SQL 2005 on a 32BIt CPU this table shows which is supported and which is not.
 
 
  Enterprise Edition1 Developer Edition Standard Edition Workgroup Edition Express Edition Evaluation Edition
Windows 2000 No No No No No No
Windows 2000 Professional Edition SP42, 4 No Yes Yes Yes Yes Yes
Windows 2000 Server SP42 Yes Yes Yes Yes Yes Yes
Windows 2000 Advanced Server SP42 Yes Yes Yes Yes Yes Yes
Windows 2000 Datacenter Edition SP42 Yes Yes Yes Yes Yes Yes
Windows XP Embedded No No No No No No
Windows XP Home Edition SP2 No Yes No No Yes No
Windows XP Professional Edition SP24 No Yes Yes Yes Yes Yes
Windows XP Media Edition SP2 No Yes Yes Yes Yes Yes
Windows XP Tablet Edition SP2 No Yes Yes Yes Yes Yes
Windows 2003 Server SP1 Yes Yes Yes Yes Yes Yes
Windows 2003 Enterprise Edition SP1 Yes Yes Yes Yes Yes Yes
Windows 2003 Datacenter Edition SP1 Yes Yes Yes Yes Yes Yes
Windows 2003 Web Edition SP1 No No No No Yes No
Windows Small Business Server 2003 Standard Edition SP1 Yes Yes Yes Yes Yes Yes
Windows Small Business Server 2003 Premium Edition SP1 Yes Yes Yes Yes Yes Yes
Windows 2003 64-Bit Itanium Datacenter Edition SP1 No No No No No No
Windows 2003 64-Bit Itanium Enterprise Edition SP1 No No No No No No
Windows 2003 64-Bit X64 Standard Edition SP1 WOW643 WOW643 WOW643 WOW643 WOW643 WOW643
Windows 2003 64-Bit X64 Datacenter Edition SP1 WOW643 WOW643 WOW643 WOW643 WOW643 WOW643
Windows 2003 64-Bit X64 Enterprise Edition SP1 WOW643 WOW643 WOW643 WOW643 WOW643 WOW643
  Enterprise Edition1 Developer Edition Standard Edition Workgroup Edition Express Edition Evaluation Edition
Windows 2000 No No No No No No
Windows 2000 Professional Edition SP42, 4 No Yes Yes Yes Yes Yes
Windows 2000 Server SP42 Yes Yes Yes Yes Yes Yes
Windows 2000 Advanced Server SP42 Yes Yes Yes Yes Yes Yes
Windows 2000 Datacenter Edition SP42 Yes Yes Yes Yes Yes Yes
Windows XP Embedded No No No No No No
Windows XP Home Edition SP2 No Yes No No Yes No
Windows XP Professional Edition SP24 No Yes Yes Yes Yes Yes
Windows XP Media Edition SP2 No Yes Yes Yes Yes Yes
Windows XP Tablet Edition SP2 No Yes Yes Yes Yes Yes

1SQL Server 2005 Evaluation Edition supports the same feature set as SQL Server 2005 Enterprise Edition, but Enterprise Edition is not supported on all of the operating systems that support Evaluation Edition.

2You can download Windows 2000 SP4 from this Microsoft Web site.

3These editions of SQL Server 2005 can be installed to the Windows on Windows (WOW64) 32-bit subsystem of a 64-bit server.

4You can install Microsoft SQL Server Books Online, client tools and some legacy tools for SQL Server 2005 Enterprise Edition on Windows 2000 Professional SP4, and Windows XP SP2. Client tools include SQL Server Management Studio, and Business Intelligence Development Studio, SQL Server 2005 software development kit. Legacy tools include Data Transformation Services Runtime and SQL-DMO.

The following limitations or issues affect installations on supported operating systems:

  • Native Web Service (SOAP/HTTP) support is only available for instances of SQL Server 2005 running on Windows 2003.

     
  • Individual topics in Microsoft SQL Server 2005 Integration Services (SSIS) programming, Analysis Management Objects (AMO), and ADOMD.NET documentation may indicate support for earlier versions of Windows, such as Windows 98, Windows ME, or Windows NT 4.0. However, for this release, these three programming interfaces are only supported on Windows XP, Windows 2000, and Windows 2003.

     
  • SQL Server 2005 failover clusters require Microsoft Cluster Server (MSCS) on at least one node of your server cluster. MSCS is only supported if it is installed on a hardware configuration that has been tested for compatibility with the MSCS software. For more information, see the topic for "Before Installing Failover Clustering" in SQL Server 2005 Books Online.

Print | posted on Tuesday, August 07, 2007 7:59 AM |

Feedback

No comments posted yet.

Post Comment

Title  
Name  
Email
Url
Comment   
Please add 3 and 2 and type the answer here:

Powered by:
Powered By Subtext Powered By ASP.NET

Copyright © Chris Crowe