Export (0) Print
Expand All

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.

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.

  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.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft