Using REPLMERG For Web Synchronization Of Anonymous Pull Subscription

Hello,

I tried to use REPLMERG utility for Web synchronization and got the following error message in log file:

2007-03-23 14:35:10.484 The subscription to publication 'X' could not be verified. Ensure that all Merge Agent command line parameters are specified correctly and that the subscription is correctly configured. If the Publisher no longer has information about this subscription, drop and recreate the subscription.

The case description is as the following:

REPLMERG utility command line:

"C:Program FilesMicrosoft SQL Server90COMREPLMERG.EXE" -ExchangeType 3 -Publication X -

Publisher B01  -Subscriber  127.0.0.1SQLEXPRESS  -Distributor B01 -PublisherDB DBS -

SubscriberDB DBS -PublisherSecurityMode 1 -Output C:TempDBS.log -OutputVerboseLevel 2  -

SubscriberSecurityMode 0 -SubscriberLogin Operator -SubscriberPassword XXX -

SubscriptionType 2 -DistributorSecurityMode 1 -Validate 3 -InternetURL

https://www.company.com/Synch/replisapi.dll -InternetSecurityMode 0 -InternetLogin USER1 -

InternetPassword PWD1 -SubscriberType 0

The subscription to the publication X has been created with the following T-SQL script:

USE DBS

EXEC sp_addmergepullsubscription

@publisher = N'B01',

@publication = N'X',

@publisher_db = N'DBS',

@subscriber_type = N'anonymous',

@sync_type = N'automatic',

@subscription_priority = 0.0;


I've also tried to check subscription information on the server 127.0.0.1SQLEXPRESS using the following:

sp_helpsubscription_properties N'B01', N'DBS', N'X'

but the result set is empty. When I run sp_helpsubscription_properties

I get the same empty result. But the subcription is anonymous and when I synchronize it using RMO - it works.

Could you please advice what could cause the problem?

Thank you.

 

Alexander.