Multiple Server Environment

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

Note

Multiple-server environment is the most common scenario for deployed applications.

Setting Up the Computer that is Running SQL Server

Using SQL Server Compact Edition in a multiple-server environment does not require the installation of any components on the SQL Server system. You only need SQL Server 2000 SP3 or later, or SQL Server 2005 installed on this computer to use remote data access (RDA) or replication with SQL Server Compact Edition.

Setting Up the Computer that is Running IIS

  1. Install IIS.

  2. Install SQL Server replication components.
    For SQL Server 2005, install the SQL Server 2005 replication components from the SQL Server 2005 product CD. For more information about how to install SQL Server 2005 replication components, see How to: Install SQL Server Replication Components.
    For SQL Server 2000 SP3a or SQL Server 2000 SP4, install the SQL Server 2000 replication components (sql2kensp3a.msi for SQL Server 2000 SP3a or sql2kensp4.msi for SQL Server 2000 SP4) from one of the two locations:

    • Microsoft Visual Studio 2005. From Windows Explorer, locate <drive>:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0 and run the sql2kensp3a.msi file.
    • Web. For information about how to install replication components from the Web, see Microsoft SQL Server 2005 Compact Edition Home.

    Note

    The SQL Server replication components are required by SQL Server Compact Edition Server Tools even if you are using RDA only to exchange data.

  3. Install SQL Server Compact Edition Server Tools (sqlce30setupen.msi) from one of the three locations:

    • Microsoft Visual Studio 2005. From Windows Explorer, locate <drive>:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0 and run the sqlce30setupen.msi file.
    • Microsoft SQL Server 2005. From Windows Explorer, locate <drive>:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE and run Sqlce30setupen.msi.
    • Web. For information about how to install SQL Server Compact Edition Server Tools from the Web, see Microsoft SQL Server 2005 Compact Edition Home.

See Also

Tasks

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

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