Using the Configure Web Synchronization Wizard

  • Article

When you use either Remote Data Access (RDA) or Replication, Microsoft SQL Server Compact 3.5 (SQL Server Compact 3.5) connects to SQL Server through a Microsoft Internet Information Services (IIS) server. SQL Server Compact 3.5 includes a connectivity wizard, Configure Web Synchronization Wizard that lets you configure connectivity for data synchronization between Microsoft SQL Server and SQL Server Compact 3.5.

Accessing Configure Web Synchronization Wizard

With the Configure Web Synchronization Wizard you can configure virtual directories, replication snapshot shares, content folders, and ISAPI .DLLs for SQL Server and for SQL Server Compact 3.5.

The Configure Web Synchronization Wizard is distributed as part of the SQL Server Compact 3.5 Server Tools installation and is included in SQL Server Management Studio. To start the wizard on the computer where SQL Server Compact 3.5 Server Tools is installed, on the Start menu, point to Programs\Microsoft SQL Server Compact, and then click Configure Web Synchronization.

In SQL Server Management Studio, the Configure Web Synchronization Wizard is displayed under the Replication node for both the SQL Server and the SQL Server Compact 3.5 object tree. To start the wizard, right-click either of these nodes, and then click Configure Web Synchronization.

You can run the Configure Web Synchronization Wizard on the server that is running Microsoft Internet Information Systems (IIS), or you can start the Configure Web Synchronization Wizard from SQL Server Management Studio on one computer and configure a virtual directory on a separate computer that is running IIS.

Important

Administrator permissions are required on both the computers that are running Configure Web Synchronization Wizard and the server that is running IIS.

Software requirements for using the Configure Web Synchronization Wizard

There are separate software requirements for the computer that is running the Configure Web Synchronization Wizard and for the computer that is running IIS that will be configured by the wizard.

On the computer that is running the Configure Web Synchronization Wizard, the Microsoft .NET Framework and wizard framework .DLLs must be installed.

On the computer that is running IIS, the following Microsoft software must be present:

  • SQL Server 2008 Replication components or SQL Server 2005 Replication components. For more information, see How to: Install SQL Server Replication Components.

  • ISAPI DLLs for SQL Server or SQL Server Compact 3.5, or both. The SQL Server ISAPI DLL is contained in the file replisapi.dll. The SQL Server Compact 3.5 ISAPI DLL, referred to as the SQL Server Compact 3.5 Server Agent, is contained in the file sqlcesa35.dll.

  • If you want to use HTTP synchronization from SQL Server Compact 3.5 to SQL Server, you must have SQL Server Compact 3.5 Server Tools installed to guarantee that the SQL Server Compact 3.5 Server Agent is present.

  • If you are configuring a virtual directory for use by SQL Server Compact 3.5, you must have SQL Server Compact 3.5 Replication Provider (sqlcerp35.dlll) installed. SQL Server Compact 3.5 Replication Provider should be installed by SQL Server Compact 3.5 Server Tools. If you are configuring a virtual directory for SQL Server, SQL Server Compact 3.5 Replication Provider is not required.

  • Microsoft Data Access Components (MDAC) 2.72 or later

    Note

    A successful installation of SQL Server Compact 3.5 Server Tools on the computer that is running IIS ensures that all the required software is installed or provides information about how to obtain any missing software.

Besides the software requirements listed earlier in this topic, Administrator permissions are required on both the computer that is running the Configure Web Synchronization Wizard and the computer that is running IIS.

Follow the steps in the wizard to do the following:

  • Connect to a virtual directory on the computer that is running IIS, or create a new virtual directory.
  • Specify the type of authentication used for client connectivity.
  • Specify information for the client to connect anonymously through IIS.
  • Choose how the client credentials will be authenticated and choose the client accounts that require access to the virtual directory.
  • Set access permissions for the replication snapshot share.

See Also

Tasks

How to: Configure Connectivity with the Configure Web Synchronization Wizard

Other Resources

Configure Web Synchronization Wizard Help

Help and Information

Getting Assistance (SQL Server Compact 3.5 Service Pack 1)