74 3
Chapter 28: Replicating Data
28
■ (^) The other difference is that you can add a value for hostname that supplies a value
to your fi lter.
Web Synchronization
One other feature of merge replication is web synchronization. Merge replication is fre-
quently used to replicate to servers in branch offi ces over WANs or the Internet. To reduce
the exposure of SQL Servers to viruses, worms, Trojan horses, and hackers, Microsoft cre-
ated web synchronization, whereby the subscriber connects to a web server over port 80
or port 443, and an ISAPI fi lter redirects traffi c to a SQL Server. Although most fi rewall
administrators are reluctant to open port 1433 (the TCP/IP port that SQL Server listens on),
they have no problem leaving port 80 or 443 open.
To confi gure web synchronization, execute the following steps:
- Connect to your publisher using SQL Server Management Studio, and expand the
Replication and Local Publications folders. - Right-click your publication, and select Confi gure Web Synchronization. Click Next.
- Specify whether your subscribers run SQL Server or SQL CE, and select Next.
- Enter the name of the web server, and choose to either create a new virtual direc-
tory or use an existing one. You receive a prompt to accept the copying of an ISAPI
extension that can process your web synchronization. Click Yes, and then click
Next to launch a dialog for Authentication Access. It is recommended that you use
Basic Authentication. - For the domain, enter the name of the domain as it appears on the certifi cate; for
the realm, enter the name of your fully qualifi ed domain name as it appears on
your certifi cate. After clicking Next, the Directory Access dialog appears. - Select an account or a group here that will be used to connect to your snapshot
share. This group should have read rights to access the snapshot share. - Click Next to advance to the Snapshot Share Access dialog. Enter the name of the
snapshot share as a UNC:\MyServerName\ShareName. The share must pre-exist. - Click Next. If you have not already confi gured a publication to use this share as its
snapshot folder, you get a prompt telling you that the share is empty. Ensure that
this is the share you want to use, and click Next to continue to the Complete the
Wizard dialog. - Confi rm your choices and click Finish.
After the Web Confi guration Wizard completes, you get a success or failure report. The lat-
ter report enables you to determine which component failed and to rerun the wizard to cor-
rect those portions.c28.indd 743c28.indd 743 7/31/2012 9:51:13 AM7/31/2012 9:51:13 AM
http://www.it-ebooks.info