Multiple Server Environment

A multiple-server environment is the most common scenario for deployed applications. In a multiple-server environment, Microsoft Internet Information Services (IIS) and Microsoft SQL Server are installed on different computers. Microsoft SQL Server Compact Server Tools must be installed on the computer that is running IIS.

Setting Up the Computer that is Running SQL Server

Using SQL Server Compact in a multiple-server environment does not require you to install components on the SQL Server system. To use remote data access (RDA) or replication with SQL Server Compact 3.5 you need SQL Server 2005 or a later version installed on the computer.

Setting Up the Computer that is Running IIS

1. Install IIS.

2. Install SQL Server replication components.
   For SQL Server 2005 or SQL Server 2008, install the replication components from the product CD. For more information, see How to: Install SQL Server Replication Components.

3. Install SQL Server Compact 3.5 Server Tools from the Microsoft Download Center:

   Important

   SQL Server Compact 3.5 Service Pack 1 (SP1) Server Tools cannot be installed side-by-side with earlier versions of Server Tools on the computer that is the IIS server. SQL Server Compact 3.5 SP1 Server Tools can replicate data between SQL Server Compact 3.5 SP1 and SQL Server 2005 and later versions. The Server tools can also support synchronization between SQL Server 2005 and SQL Server Compact 3.1. SQL Server Compact 3.5 SP1 Server Tools also supports data replication between SQL Server 2005 Compact Edition or SQL Server 2005 Mobile Edition and SQL Server 2005 and later versions.

See Also

Tasks

How to: Install SQL Server Replication Components
How to: Install Server Tools (SQL Server Compact)

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)