How to: Install Server Tools (SQL Server Compact)

  • Article

This topic describes how to install the SQL Server Compact 3.5 Server Tools on a computer that is running Microsoft Internet Information Services (IIS). SQL Server Compact 3.5 Server Tools installs the replication components on the computer that is running IIS. The replication components are required for connecting the SQL Server Compact 3.5 database to a SQL Server database. You can download SQL Server Compact 3.5 Server Tools from Microsoft SQL Server Compact Download Site. For information about 64-bit replication components, see Managing 64-bit Database Applications.

This procedure assumes that you have installed SQL Server 2005 or a later version connectivity components, and that the computer is running IIS version 5.0, or a later version. If you are running IIS 7.0, you must install IIS 6 Management Compatibility pack.

Important

Using SQL Server Compact 3.5 Server Tools with SQL Server 2008 is not supported in the production environment. SQL Server Compact 3.5 SP1 Server Tools is supported.

To install Server Tools

  1. Download the SQL Server Compact 3.5 Server Tools msi file from Microsoft SQL Server Compact Download Site. Double-click SSCEServerTools-ENU.msi.

  2. Click Next.

  3. Review the License Agreement, and then click Next.

  4. If the System Configuration Check passes all checks, click Next. Otherwise, for information about how to correct the problem, click More next to the failed checks.

  5. The installation wizard automatically detects the versions of SQL Server to which you can synchronize data. The default path is <drive>:\Program Files\Microsoft SQL Server Compact Edition.

  6. Click Next.

  7. Click Install.

  8. Click Finish.