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
- Install IIS.
- Install SQL Server 2005 or SQL Server 2000 SP3 or later.
- 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)