Using the Configure Web Synchronization Wizard
When you use either Remote Data Access (RDA) or Replication, Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) connects to SQL Server through a Microsoft Internet Information Services (IIS) server. SQL Server Compact Edition includes a connectivity wizard, Configure Web Synchronization Wizard that lets you configure connectivity for data synchronization between Microsoft SQL Server and SQL Server Compact Edition.
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 Edition.
The Configure Web Synchronization Wizard is distributed as part of the SQL Server Compact Edition Server Tools installation and is included in SQL Server Management Studio. To start the wizard on the computer where SQL Server Compact Edition Server Tools is installed, on the Start menu, point to Programs\Microsoft SQL Server 2005 Compact Edition, 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 Edition 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 IIS computer.
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 2005 Replication components or SQL Server 2000 Replication components. For more information, see How to: Install SQL Server Replication Components.
ISAPI DLLs for SQL Server or SQL Server Compact Edition, or both. The SQL Server ISAPI DLL is contained in the file sqlisapi.dll. The SQL Server Compact Edition ISAPI DLL, referred to as the SQL Server Compact Edition Server Agent, is contained in the file sqlcesa30.dll.
If you want to use HTTP synchronization from SQL Server Compact Edition to SQL Server, you must have SQL Server Compact Edition Server Tools installed to guarantee that the SQL Server Compact Edition Server Agent is present.
If you are configuring a virtual directory for use by SQL Server Compact Edition, you must have SQL Server Compact Edition Replication Provider (sscerp30.dll) installed. SQL Server Compact Edition Replication Provider should be installed by SQL Server Compact Edition Server Tools. If you are configuring a virtual directory for SQL Server, SQL Server Compact Edition Replication Provider is not required.
Microsoft Data Access Components (MDAC) 2.72 or later
Note
A successful installation of SQL Server Compact Edition 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
Reference
Configure Web Synchronization Wizard Help