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
Install IIS.
Install SQL Server replication components.
For SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 install the replication components from the product CD. For more information, see How to: Install SQL Server Replication Components.
Install SQL Server Compact 3.5 Server Tools from the Microsoft Download Center:
SQL Server Compact 3.5 Service Pack 2 (SP2) 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 SP2 Server Tools can replicate data between SQL Server Compact 3.5 SP2 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 SP2 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.
Tasks
How to: Install SQL Server Replication Components
How to: Install Server Tools (SQL Server Compact)
Concepts
Using Remote Data Access (RDA)