Single Server Environment

In a single-server environment, one computer contains the SQL Server Compact environment. Internet Information Services (IIS), SQL Server, and SQL Server Compact Server Tools are installed on that same computer. You must have Administrator permissions on the computer.

Setting Up a Single Server Environment

  1. Install IIS.
  2. Install SQL Server 2008 or SQL Server 2005.
  3. Install SQL Server Compact Server Tools.

To use replication or remote data access (RDA) with SQL Server Compact, SQL Server Compact Server Tools is required. If multiple computers are running IIS in your SQL Server Compact environment, each computer that is running IIS must have SQL Server Compact Server Tools installed. Administrator permissions are required on the computer where SQL Server Compact 3.5 Server Tools is installed.

Note

After you install the latest release of SQL Server Compact Server Tools, do not install SQL Server Mobile Server Tools, SQL Server CE Server Tools 2.0, or SQL Server CE Replication Provider 2.0. This will cause a synchronization failure. Install the latest release of SQL Server Compact Server Tools last.

The following table shows the files that are added to the desktop after you install SQL Server Compact Server Tools (SSCEServerTools-ENU.msi).

Component File name

SQL Server Compact Server Agent

sqlcesa35.dll

SQL Server Compact Replication Provider

sqlcerp35.dll

Configure Web Synchronization Wizard

ConnWiz.exe

Supporting files

Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll

Microsoft.SqlServer.WizardFramework.dll

Microsoft.SqlServer.GridControl.dll

Microsoft.SqlServer.CustomControls.dll

Microsoft.VisualStudio.VSHelp.dll

Microsoft.VisualStudio.VSHelp80.dll

For more information, see How to: Install Server Tools (SQL Server Compact).

Note

If you try to install SQL Server Compact Server Tools to a directory without read permissions (deny read permissions only), you will receive a warning. If you continue, the tools are installed 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)

Help and Information

Getting Assistance (SQL Server Compact 3.5 Service Pack 1)