Hardware and Software Requirements
The tables in this topic describe the hardware and software requirements for each system that Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE) interacts with. For more information, see SQL Server CE Environment.
|Development environment||45 MB of available disk space. The computer must have an additional 45 MB of temporary storage space for the setup files.|
|Microsoft Windows CE-based device |
|Between 1 and 3 MB of available storage space, depending on processor type and components installed. |
The file sizes for the SQL Server CE components vary by processor type and version of the Windows CE operating system. Space requirements also depend on the development environment and which SQL Server CE components you install.
|Microsoft SQL Server system |
|For more information, see "Installing SQL Server" in SQL Server Books Online.|
|Microsoft Internet Information Services (IIS) system |
|120 MB of available disk space.|
Operating System Requirements
|Platform||Supported operating systems|
|Development environment||Microsoft Windows 2000 and Windows XP. Microsoft ActiveSync® 3.1 or later is required.|
|SQL Server system |
|For information, see "Installing SQL Server" in SQL Server Books Online.|
|IIS system (server environment)||Microsoft Windows 2000 and Windows XP. Windows NT 4.0 is supported only for manual configurations of the SQL Server CE Server Agent.|
|Windows CE-based device: ||Microsoft Windows Powered Pocket PC 2002, Pocket PC 2000, and Handheld PC 2000. Microsoft Windows CE .NET version 4.1 (Platform Builder) is supported for embedded devices.|
SQL Server Requirements
|SQL Server||Supported SQL Server CE features|
|SQL Server 2000 with Service Pack 1 or higher||Merge replication and remote data access (RDA) are supported.|
|SQL Server version 7.0 with Service Pack 3 or higher||RDA is supported; replication is not supported.|
RDA and replication require that Microsoft Data Access Components (MDAC) 2.6 or later be present on the Microsoft Internet Information Services (IIS) system. If MDAC 2.6 or later is not present on the IIS system, SQL Server CE Setup installs it when you specify the Server Tools installation option or launch the self-extracting SQL Server CE Server Tools installation file (Sqlce20sql2ksp1.exe or Sqlce20sql2ksp2.exe).
SQL Server CE RDA and replication are supported with computers running any edition of Microsoft SQL Server 2000 with Service Pack 1 or higher. SQL Server CE replication is not supported with earlier versions of SQL Server. RDA is supported on SQL Server 7.0, but only in a multiple-server environment; if IIS and SQL Server are installed on the same computer (a single-server environment) SQL Server 2000 with Service Pack 1 or higher is required.
IIS and Internet Explorer Requirements
|Microsoft Internet Explorer 5.0||Internet Explorer 5.0 or later is required on the development system to access SQL Server CE Books Online. |
Internet Explorer 5.0 or later is required on the IIS system.
|Microsoft Internet Information Services (IIS)||IIS versions supported on Microsoft Windows NT 4.0 with SP5 or higher, Microsoft Windows 2000 and Microsoft Windows XP.|
|ActiveSync 3.1||Microsoft Windows 98 Second Edition, Windows Millennium Edition, Windows NT® 4.0 with Service Pack 5 or later, or Windows 2000.|
|ActiveSync 3.5 (Recommended)||Microsoft Windows 98 Second Edition, Windows Millennium Edition, Windows NT 4.0 with Service Pack 6 or later, Windows 2000, or Windows XP.|