Web synchronization option for merge replication

Configuring Web Synchronization

• Configuring the Publication : How to: Configure a Publication to Allow for Web Synchronization (SQL Server Management Studio)
• Configuring the Computer That Is Running IIS: How to: Configure IIS for Web Synchronization

A. Configuring Secure Sockets Layer: Download and install SelfSSL for free

B. Configuring the Computer That Is Running IIS by Using the Configure Web Synchronization Wizard:

"

On the computer that is running IIS, start SQL Server Management Studio.
Connect to the Publisher, and then expand the server node.
Expand the Local Publications folder, right-click the publication, and then click Configure Web Synchronization.
In the Configure Web Synchronization Wizard, on the Subscriber Type page, select SQL Server.
On the Web Server page:
Select the instance of IIS that will synchronize subscriptions.
Select Create a new virtual directory.
In the lower pane of the page, expand the instance of IIS, expand Web Sites, and then click Default Web Site.
On the Virtual Directory Information page:
In the Alias box, enter an alias for the virtual directory.
In the Path box, enter a path of the virtual directory. For example, if you entered websync1 in the Alias box, enter C:\Inetpub\wwwroot\websync1 in the Path box. Click Next.
On both dialog boxes, click Yes. This specifies that you want to create a new folder and that you want to copy the SQL Server Internet Server API (ISAPI) DLL. .
On the Authenticated Access page:
Make sure that Integrated Windows authentication and Digest authentication for Windows domain servers are cleared.
Select Basic Authentication.
In the Default Domain and Realm boxes, enter the domain of the computer that is running IIS.
On the Directory Access page:
Click Add, and then in the Select Users or Groups dialog box, add the accounts under which Subscribers will make connections to IIS. These are the accounts that you will specify on the Web Server Information page of the New Subscription Wizard or as the value for the sp_addmergepullsubscription_agent @internet_login parameter.
On the Snapshot Share Access page, enter the snapshot share. The appropriate permissions are set on this share so that Subscribers can access the snapshot files. For more information about permissions for the share, see Securing the Snapshot Folder.
On the Completing the Wizard page, click Finish.
If a failure occurs, such as a network error while trying to configure a remote computer that is running IIS, all completed actions are rolled back and all remaining actions are canceled. If a completed action cannot be rolled back, the status in the final page of the wizard displays Success and the completed actions remain committed.
If the computer that is running IIS is running on a 64-bit version of Microsoft Windows, replisapi.dll must be copied to the appropriate directory:
Click Start, and then click Run. In the Open box, enter iisreset, and then click OK.
After IIS stops and restarts, copy replisapi.dll from :\Program Files\Microsoft SQL Server\90\COM\replisapi to the directory that is specified in step 6b.
Click Start, and then click Run. In the Open box, enter cmd, and then click OK.
In the directory that you specified in step 6b, execute the following command:regsvr32 replisapi.dll

"

C. Setting Permissions for the SQL Server Replication Listener:

"To configure the account and permissions

Create a local account on the computer that is running IIS:
Right-click My Computer, and then click Manage.
In Computer Management, expand Local Users and Groups.
Right-click Users, and then click New User.
Enter a user name and a strong password.
Click Create, and then click Close.
Add the account to the IIS_WPG group:
In Computer Management, expand Local Users and Groups, and then click Groups.
Right-click IIS_WPG, and then click Add to Group.
In the IIS_WPG Properties dialog box, click Add.
In the Select Users, Computers, or Groups dialog box, add the account created in step 1.
Make sure that the name in the From this location field is the name of the local computer instead of a domain. If the name is not a local computer, click Locations. In the Locations dialog box, elect the local computer, and then click OK.
In the Select Users dialog box and the IIS_WPG Properties dialog box, click OK.
Grant the minimum permissions on the folder that contains replisapi.dll to the account :
Locate the folder that you created for replisapi.dll, right-click the folder, and then click Sharing and Security.
On the Security tab, click Add.
In the Select Users, Computers, or Groups dialog box, add the account that you created in step 1.
Make sure that the name in the From this location field is the name of the local computer instead of a domain. If the name is not a local computer, click Locations. In the Locations dialog box, select the local computer, and then click OK.
Make sure that the account is granted only Read, Read & Execute, and List Folder Contents permissions.
Select any users or groups that do not require access to the directory, and then click Remove.
Click OK.
Create an application pool in Internet Information Services (IIS) Manager:
Click Start, and then click Run.
In the Open box, type inetmgr, and then click OK.
In Internet Information Services (IIS) Manager, expand the local computer node.
Right-click Application Pools, point to New and then click Application Pool.
Enter a name for the pool in the Application pool ID field, and then click OK.
Associate the account with the application pool:
In Internet Information Services (IIS) Manager, expand the local computer node, and then expand Application Pools.
Right-click the application pool that you created, and then click Properties.
In the Properties dialog box, on the Identity tab, click Configurable.
In the User name and password fields, enter the account and password that were created in step 1.
Click OK.
Associate the application pool with the virtual directory that is used for Web synchronization:
In Internet Information Services (IIS) Manager, expand the local computer node, and then expand Web Sites.
Expand the Web site that you are using for Web synchronization, right-click the virtual directory that you created for Web synchronization, and then click Properties.
On the Virtual Directory tab of the Properties dialog box, from the Application pool drop-down list, select the application pool that was created in step 5.
Click OK.

"

• Configure one or more subscriptions to use Web synchronization