How to: Configure Connectivity with the Configure Web Synchronization Wizard

  • Article

In this topic, you will configure Microsoft Internet Information Services (IIS) to permit Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) subscribers to connect to a SQL Server Publication. This topic assumes that you have installed and configured IIS on a server, that you can access that server from the computer on which you run the Configure Web Synchronization Wizard, and that you have administrative access to the server. The Configure Web Synchronization Wizard steps assume that you have already configured a snapshot share for replication. If you have not yet configured a Publication, see How to: Create a Publication for SQL Server Compact Edition Subscriptions (SQL Server Management Studio).

To run the Configure Web Synchronization Wizard

  1. Click Start, point to All Programs, point to Microsoft SQL Server 2005 Compact Edition, and then click Configure Web Synchronization Wizard.

  2. On the Introduction screen, click Next.

  3. On the Subscriber Type screen, select SQL Server Compact Edition, and then click Next.

  4. In the Web Server page, enter the name of the computer on which the virtual directory will be created. If you want to create a new virtual directory that SQL Server Compact Edition subscribers will use, choose Create a new virtual directory, and then choose the Web site in which to create the new directory. Otherwise, choose Configure an existing virtual directory, and then select the directory from the list. When you have made your selection, click Next. The remaining steps assume that you are creating a new virtual directory.

  5. In the Alias text box, type a name for the new virtual directory. In the Path text box, set the local file path for the virtual directory, and then click Next.

  6. The Secure Communications page of the Configure Web Synchronization Wizard configures Secure Sockets Layer (SSL) settings for encrypted communication. Select the appropriate settings and click Next.

Note

For more information, see Secure Communications.

  1. On the Client Authentication page, select the type of authentication you will use for authenticating all SQL Server Compact Edition subscribers, and then click Next. The following steps assume that you choose to use Authentication instead of permitting Anonymous access.
  2. On the Authenticated Access page, select the kinds of authentication you will use, provide any additional information required for the selected authentication type, and then click Next. The following steps assume that you have chosen to use Integrated Windows Authentication only.
  3. On the Directory Access page, add the user or group accounts that will have access to the virtual directory, and then click Next.
  4. On the Snapshot Share Access page, provide the Universal Naming Convention (UNC) path of the snapshot share, and then click Next.
  5. Click Finish to create and configure the virtual directory, and then click Close when the wizard finishes.

See Also

Tasks

How to: Create a Publication for SQL Server Compact Edition Subscriptions (SQL Server Management Studio)

Other Resources

Installing SQL Server Compact Edition
Managing Connectivity (SQL Server Compact Edition)

Help and Information

Getting SQL Server Compact Edition Assistance