Single Server Environment

In a single-server environment, one computer contains the Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) environment. Microsoft SQL Server, Internet Information Services (IIS), and SQL Server 2005 Compact Edition Server Tools are installed on that computer. Administrator permissions are required on that computer.

Setting Up a Single Server Environment

  1. Install IIS.
  2. Install SQL Server 2005 or SQL Server 2000 SP3 or later.
  3. Install SQL Server Compact Edition Server Tools.
    When you use SQL Server Compact Edition, SQL Server Compact Edition Server Tools is required to use replication or remote data access (RDA). If you have multiple computers that are running IIS in your SQL Server Compact Edition environment, each computer that is running IIS must have SQL Server Compact Edition Server Tools installed. Administrator permissions are required on the computer where SQL Server Compact Edition Server Tools is installed.

Note

Do not install SQL Server CE Server Tools 2.0 and SQL Server CE Replication Provider 2.0 after installing SQL Server 2005 Compact Edition Server Tools. This causes synchronization failure.

The following files are added to the desktop after installing SQL Server Compact Edition Server Tools (sqlce30setupen.msi).

Component File name

SQL Server Compact Edition Server Agent

sqlcesa30.dll

SQL Server Compact Edition Replication Provider

sqlcerp30.dll

Configure Web Synchronization Wizard

connwiz30.exe and supporting files

SQL Server Compact Edition Books Online

sqlce30.hxs

For more information about how to install SQL Server Compact Edition Server Tools, see How to: Install Server Tools (SQL Server 2005 Compact Edition).

Note

If you try to install SQL Server Compact Edition Server Tools to a directory without read permissions (deny read permissions only), you will receive a warning. If you continue, the tools are installed successfully, but when you uninstall them, you will receive an error, and the files will be neither unregistered nor deleted.

See Also

Concepts

Connectivity Overview
Using Remote Data Access (RDA)
Using Merge Replication

Other Resources

Managing Connectivity (SQL Server Compact Edition)

Help and Information

Getting SQL Server Compact Edition Assistance