Microsoft KB Archive/839278

= BUG: The changes in a remote subscriber are not updated to the publisher for a queued updating replication that uses Message Queuing on a computer that is running Windows XP Service Pack 2 =

Article ID: 839278

Article Last Modified on 5/13/2005

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft Windows XP Embedded

-



SYMPTOMS
After you install Microsoft Windows XP Service Pack 2 on a computer that is configured as a distributor, if you try to synchronize data from a subscriber that is configured on a remote computer, you may notice that the changes that are made in the subscriber database are not updated to the publisher database. This problem occurs when both the following are true:
 * The publication and the subscription of the replication are configured for queued updating.
 * Message Queuing (also known as MSMQ) is used to queue the transactions at the remote subscriber.

This problem may also occur after you install Windows XP SP2 on computers that are configured as a publisher or a subscriber.



CAUSE
This problem occurs because Windows Firewall is blocking the Message Queuing service.

Typically, messages that correspond to the changes in the remote subscriber are posted to a queue that is local to the remote subscriber. The messages are then transmitted by the Message Queuing service to a queue that is local to the computer that is configured as the distributor.

By default, when you install Microsoft Windows XP Service Pack 2, Windows Firewall is turned on. Because Windows Firewall is blocking the Message Queuing service, the messages that correspond to the changes in the remote subscriber will not be transmitted.



WORKAROUND
To work around this problem, you must add the Message Queuing service as an exception in the Windows Firewall configuration on the computer that is running Windows XP SP2. To do this, follow these steps:
 * 1) Click Start, and then click Run.
 * 2) In the Run dialog box, type Firewall.cpl, and then click OK.
 * 3) In the Windows Firewall dialog box, click the Exceptions tab.
 * 4) On the Exceptions tab, click Add Program.
 * 5) In the Add a Program dialog box, click the Browse button, and then locate the Mqsvc.exe file. By default, the file is stored in the following folder:


 * 1) Double-click the Mqsvc.exe file.
 * 2) In the Add a Program dialog box, click OK.
 * 3) Under Programs and Services, click to select the Mqsvc option, and then click OK.

