SQL Server, in addition to being available in a number of editions, also runs on a number of Windows platforms. However, certain editions will only run on certain platforms. This section takes a look at the platforms on which SQL Server runs and the editions it supports.
Windows 98 and Windows Me
Windows 98 and Windows Me are designed primarily for the home PC user . Windows 98 is still in use on the desktop in many corporate shops as well. Windows 98 and Windows Me are intended to support mobile users who are disconnected from the network but need to run applications that require SQL Server data storage, or for users who need to run local applications that require local SQL Server data storage on the computer.
For these purposes, the Windows 98 and Windows Me platforms support the SQL Server 2000 Standard Edition and the SQL Server 2000 Desktop Engine. Although the Full Text Search and Analysis Services are included with the Personal Edition of SQL Server, they cannot be installed on Windows 98 or Windows Me. Also, because Windows 98 and Windows Me do not support applications running as services, SQL Server and SQL Task Manager run as standard executables on Windows 98 and Windows Me rather than as services, as they do under Windows NT or Windows 2000.
The Windows 98 and Windows Me environments also support the installation of the SQL Server client tools, such as Query Analyzer, Enterprise Manager, and SQL Profiler. The connectivity components needed to connect to any SQL Server 2000 edition running on a Windows NT or Windows 2000 workstation or server can be installed on Windows 98, Windows Me, or Windows 95.
Windows NT 4.0
Windows NT is the original platform for Microsoft SQL Server versions 6.0 and later. SQL Server 2000 is still supported on all Windows NT 4.0 platforms, including Workstation, Server, and Enterprise Server. However, Windows NT 4.0 Service Pack 5 or later must be installed to run SQL Server 2000.
Windows NT 4.0 Workstation is the platform intended for the corporate desktop. It sports a Windows 95 “like interface with the underlying reliability and security of Windows NT. Windows NT 4.0 Server is the server edition of Windows NT 4.0, which also sports a Windows 95-like interface as well as increased scalability. Windows NT 4.0 Server includes Internet Information Server for tighter integration with Internet and Web-based applications. The Enterprise Edition of Windows NT 4.0 Server is a more high- powered version of NT 4.0 Server, providing greater scalability (up to eight processors), clustering capability, and multinode load balancing. Windows 4.0 Server Enterprise Edition is the platform to use when deploying largescale distributed applications.
All Windows NT 4.0 platforms support the Developer, Personal, and Desktop Engine editions of SQL Server 2000. The Standard and Enterprise editions can be installed on Windows NT 4.0 Server and Windows NT 4.0 Server Enterprise Edition.
Although SQL Server 2000 runs in the Windows 98, Windows Me, and Windows NT 4.0 environments, it is best suited for the Windows 2000 environments. Windows 2000 is the evolution of Windows NT 4.0 and sports a Windows 98 “like user interface. Windows 2000 is available in a Professional Edition and Server Edition.
Windows 2000 Professional
Windows 2000 Professional is the version of Windows 2000 geared toward the corporate desktop and laptop. Windows 2000 provides better power management and hardware support for use on notebooks than Windows NT 4.0. Windows 2000 Professional is a more reliable and stable platform than Windows 98 or Windows Me, and even more reliable and stable than Windows NT 4.0 Workstation. Windows 2000 Professional offers high system uptime, dynamic system configuration, and resilience to application failures. It is an ideal environment for application development.
Windows 2000 Professional supports SQL Server 2000 Personal, Desktop Engine, and Developer Editions.
Windows 2000 Server Family
The Windows 2000 family supports three server platforms:
Windows 2000 Server
Windows 2000 Server is the next generation of Windows NT 4.0 Server, providing improved reliability and scalability. Windows 2000 Server supports up to 4GB of memory and up to four processors. Windows 2000 Server supports the installation of the Enterprise, Developer, Standard, Personal, and Desktop Engine Editions of SQL Server 2000.
Windows 2000 Server Advanced Server
Windows 2000 Advanced Server is the next generation of Windows NT 4.0 Server Enterprise Edition, providing improved reliability and scalability with support for up to 8GB of memory and eight processors. Like NT 4.0 Enterprise Edition, Windows 2000 Advanced Server provides support for clustering and multinode load balancing.
Windows 2000 Advanced Server supports the installation of all editions of SQL Server 2000, except SQL Server Windows CE Edition.
Windows 2000 Datacenter Server
The Windows 2000 Datacenter Server is a new addition to the Windows Server family. It is intended for largescale Enterprise-wide business applications. Windows 2000 Datacenter Server is like a pumped-up version of Windows 2000 Advanced Server with support for 32-way symmetric multiprocessing and up to 64GB of physical memory on systems that support it. It also provides 4-node clustering and up to 32-node network load balancing.
Windows 2000 Datacenter Server supports the installation of all editions of SQL Server 2000, except SQL Server 2000 Windows CE Edition.
Windows XP is the continued evolution of Windows 2000 and was designed to bridge the gap between the home and business user by being one operating system that meets the needs of both types. Windows XP is based upon the proven, reliable Windows 2000 Professional platform with improvements to the user interface for ease-of-use, home networking, and enhanced online capabilities.
Windows XP is available in two editions: Windows XP Home Edition for home use and Windows XP Professional for power users and business users. Windows XP Professional includes all the capabilities of Windows XP Home Edition plus important features to meet the demanding needs of business and power users, such as enhanced networking, security, management, and support capabilities. These features provide functionality that is critical for businesses, but might not be needed by most home users.
The advanced features of Windows XP include the following:
Both Windows XP Home Edition and Windows XP Professional support SQL Server 2000 Personal, Desktop Engine, and Developer Editions.
Windows CE is the modular real-time embedded operating system used in small footprint and mobile devices, such as Pocket PCs. Windows CE provides a Windows-like interface and Windows compatibility for consumer electronic devices, Web terminals, Internet access appliances, specialized industrial controllers, mobile data acquisition handhelds, and embedded communication devices. Windows CE allows developers to build applications for small footprint and mobile 32-bit devices that can integrate more seamlessly with Windows and the Internet.
Windows CE versions 2.11 and later support running SQL Server 2000 Windows CE Edition.
SQL Server 2000 Edition/Platform Matrix
Are you confused yet? Keeping track of which editions of SQL Server run on which Windows platform can be difficult. To help you, Table 2.1 summarizes the various platforms and the editions of SQL Server that are supported.
Table 2.1. SQL Server Editions Supported on Windows Platforms