Share via

  • Article

This topic lists the hardware and software requirements for Microsoft SQL Server Compact 3.5  Service Pack 2 (SP2).

System Requirements

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

Environment

Requirements

Development environment

  • .NET Framework (for Windows desktop):

  • .NET Compact Framework (for Windows Mobile):

  • Microsoft Visual Studio 2008 or later versions.

    • To develop applications for Windows desktop, use Visual Studio 2010. You can also use Visual Studio 2008 SP1 to develop desktop applications for SQL Server Compact 3.5 SP2; however, Visual Studio 2010 provides new features such as support for Transact-SQL Query Editor that are not available with Visual Studio 2008 SP1.

    • To develop applications for Windows Mobile, use Visual Studio 2008 SP1. Visual Studio 2010 does not support the development of mobile applications for SQL Server Compact 3.5.

    You do not need to install .NET Framework separately if you use Visual Studio as the development environment. Visual Studio installs .NET Framework. For information about system requirements, see Visual Studio Books Online.

  • Microsoft ActiveSync 4.0 or later versions.

Client environment

Desktop and Tablet PC platforms:

  • Microsoft Windows XP Professional SP3 

  • Microsoft Windows XP Home Edition SP3 

  • Microsoft Windows XP Media Center Edition 2004 SP3 

  • Microsoft Windows XP Media Center Edition 2005

  • Microsoft Windows XP Tablet PC Edition SP3 

  • Microsoft Windows XP Embedded SP3

  • Microsoft Windows XP Professional x64 SP3 

  • Windows Embedded for Point of Service SP3

  • Microsoft Windows Server 2003, Standard Edition SP2 

  • Microsoft Windows Server 2003, Enterprise Edition SP2 

  • Microsoft Windows Server 2003, Datacenter Edition SP2 

  • Microsoft Windows Server 2003 R2, Standard Edition

  • Microsoft Windows Server 2003 R2, Enterprise Edition

  • Microsoft Windows Server 2003 R2, Datacenter Edition

  • Microsoft Windows Server 2003 x64, Standard Edition SP2

  • Microsoft Windows Server 2003 x64, Enterprise Edition SP2

  • Microsoft Windows Server 2003 x64,, Datacenter Edition SP2

  • Microsoft Windows Server 2003 R2 x64, Standard Edition

  • Microsoft Windows Server 2003 R2 x64, Enterprise Edition

  • Microsoft Windows Server 2003 R2 x64, Datacenter Edition 

  • Windows Vista Home Basic SP2

  • Windows Vista Home Premium SP2

  • Windows Vista Business SP2

  • Windows Vista Enterprise SP2

  • Windows Vista Ultimate SP2

  • Windows Vista Starter Edition SP2

  • Windows Vista Home Basic x64 SP2

  • Windows Vista Home Premium x64 SP2

  • Windows Vista Business x64 SP2

  • Windows Vista Enterprise x64 SP2

  • Windows Vista Ultimate x64 SP2 

  • Windows Server 2008 Standard Server SP2

  • Windows Server 2008 Standard Server SP2 (without Hyper-V)

  • Windows Server 2008 Enterprise SP2

  • Windows Server 2008 Enterprise SP2 (without Hyper-V)

  • Windows Server 2008 Data Center SP2

  • Windows Server 2008 Data Center SP2 (without Hyper-V)

  • Windows Server 2008 Web Edition SP2

  • Windows Server 2008 Standard Server x64 SP2

  • Windows Server 2008 Standard Server x64 SP2 (without Hyper-V)

  • Windows Server 2008 Enterprise x64 SP2 

  • Windows Server 2008 Enterprise x64 SP2 (without Hyper-V)

  • Windows Server 2008 Data Center x64 SP2

  • Windows Server 2008 Data Center x64 SP2 (without Hyper-V)

  • Windows Server 2008 Web Edition x64 SP2

  • Windows 7 Starter

  • Windows 7 Starter x64

  • Windows 7 Home Premium

  • Windows 7 Home Premium x64

  • Windows 7 Professional

  • Windows 7 Professional x64

  • Windows 7 Ultimate

  • Windows 7 Ultimate x64

  • Windows Server 2008 R2 Foundation x64

  • Windows Server 2008 R2 Standard x64

  • Windows Server 2008 R2 Enterprise x64

  • Windows Server 2008 R2 Datacenter x64

  • Windows Web Server 2008 R2 x64

Mobile device platforms:

  • Microsoft Windows CE 4.2

  • Microsoft Windows CE 5.0

  • Microsoft Windows CE 6.0

  • Microsoft Windows Mobile 2003 for Pocket PC

  • Microsoft Windows Mobile 5.0

  • Microsoft Windows Mobile 6.0

  • Microsoft Windows Mobile 6.5

  • Between 2 MB and 3 MB of available storage space, depending on processor type and components installed.

Server environment¹

  • SQL Server 2008 R2 or later versions

  • SQL Server 2008 or later versions

  • SQL Server 2005 or later versions

    Intel or compatible Pentium 600 MHz or faster processor (recommended processor speed is 1 GHz or faster), 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 2008 R2" in SQL Server 2008 R2 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.

    For IIS 7.0, the IIS 6.0 backward compatibility components need to be installed.

  • Microsoft ActiveSync 4.0 or later versions

    Required when you use SQL Server 2008 R2 Management Studio to manage SQL Server Compact databases on connected devices. 

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

SQL Server Replication Components Requirements

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

SQL Server version

Required replication components on the computer that is running IIS

SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2

Install the SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 replication components from the product CD.

Tasks

How to: Install SQL Server Replication Components

Concepts

Installing a Development Environment

Installing a Server Environment

Installing and Deploying on a Device (SQL Server Compact)

Single Server Environment

Multiple Server Environment