Export (0) Print
Expand All

Hardware and Software Requirements

This topic covers the hardware and software requirements for Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition).

The following table lists the hardware and software requirements for the three SQL Server Compact Edition environments: development, client, and server environment. For more information about the different environments, see Architecture (SQL Server Compact Edition) and Installing SQL Server Compact Edition.

Environment Requirements

Development environment

  • Microsoft Visual Studio 2005 or later
    For information about hardware requirements, see Visual Studio 2005 Books Online.
  • Microsoft Internet Explorer 6.0 or later versions
    Required to access SQL Server Compact Edition Books Online
    Microsoft ActiveSync 4.0 or later versions

Client environment

Desktop and Tablet PC platforms:

  • Microsoft Windows XP Professional SP2
  • Microsoft Windows XP Home Edition SP2
  • Microsoft Windows XP Media Center Edition 2002 SP2
  • Microsoft Windows XP Media Center Edition 2004 SP2
  • Microsoft Windows XP Media Center Edition 2005
  • Microsoft Windows XP Tablet PC Edition SP2
  • Microsoft Windows Server 2003, Standard Edition SP1
  • Microsoft Windows Server 2003, Enterprise Edition SP1
  • Microsoft Windows Server 2003, Datacenter Edition SP1
  • Microsoft Windows Server 2003 R2, Standard Edition
  • Microsoft Windows Server 2003 R2, Enterprise Edition
  • Microsoft Windows Server 2003 R2, Datacenter Edition
  • Microsoft Windows Professional 2000 SP4
  • Microsoft Windows Server 2000 SP4

Mobile device platforms:

  • Microsoft Windows CE 4.2
  • Microsoft Windows CE 5.0
  • Windows Mobile 2003 Software for Pocket PC
  • Windows Mobile 5.0
  • Between 2 MB and 3 MB of available storage space, depending on processor type and components installed.

Server environment¹

  • Microsoft SQL Server 2000 SP3a or later versions
  • SQL Server 2005 or later versions
    Intel or compatible Pentium 600 MHz or greater processor (recommended processor speed is1 GHz or greater), 256 MB RAM minimum (recommended RAM 512 MB or more), hard disk space 250 MB
    For information about operating system requirements, see "Hardware and Software Requirements for Installing SQL Server 2005" in SQL Server 2005 Books Online.
  • IIS 5.x or later versions
    Supported on Windows Server 2003, Windows 2000 SP4 or later versions, and Windows XP
    120 MB of available disk space on the server
  • Microsoft ActiveSync 4.0 or later versions
    Required when you use SQL Server 2005 Management Studio to manage SQL Server Compact Edition databases on connected devices.
  • Microsoft Internet Explorer 6.0 or later versions
    Note:
    Microsoft Outlook 98 or a later version is required for synchronization of e-mail, calendar, contacts, tasks, and notes to the desktop or portable computer. (Outlook 2003 recommended)

¹ Server environment can be set up either on one computer (single server environment) or multiple computers (multiple server environment). For more information, see Installing a Server Environment.

In a multiple-server environment, to exchange data between SQL Server Compact Edition and SQL Server, you have to install replication components on the computer that is running IIS. The following table lists how to install the replication components on two different versions of SQL Server.

SQL Server version Required replication components on the computer that is running IIS

SQL Server 2005 and later versions

Install the SQL Server 2005 replication components from the SQL Server 2005 product CD.

SQL Server 2000 SP4

Install the SQL Server 2000 replication components (sql2kensp4.msi) from one of the two locations:

  • Microsoft Visual Studio 2005. From Windows Explorer, locate drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0 and run the sql2kensp4.msi file.
  • Web. For information about how to install replication components from the Web, see Connectivity Tools Page.

SQL Server 2000 SP3a

Install the SQL Server 2000 replication components (sql2kensp3a.msi) from one of the two locations:

  • Microsoft Visual Studio 2005. From Windows Explorer, locate drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0 and run the sql2kensp3a.msi file.
  • Web. For information about how to install replication components from the Web, see Connectivity Tools Page.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft