May 9, 2015 at 8:20 pm
I'm trying out a set up as following:
SQL Server 2008 standard as the publisher
SQL Server 2012 express as the subscriber
and I tend to use web synchronization; there is no domain trust.
After following the instructions at MSDN for configuring web synchronization, I have an error that I can't get past - after creating the initial snapshot on the publisher, I try to run replmerg.exe at the subscriber and I always get this error:
"The subscription to publication 'TestReplication' has expired or does not exist."
If I refresh the publisher's "Local Publications" and look within the "TestReplication", it does show that the subscriber is a known subscriber. Likewise, if I refresh subscriber's "Local Subscription", it has an entry for TestReplication publication.
I already verified that the user used by Replisapi.dll has the read permission to the snapshot folder, is a member of PAL, is db_owner of the publishing database and distribution database. I am using self-signed certificate for this test and I have already installed the certificate at the subscriber machine so that HTTPS is trusted. I can run diagnosis from subscriber so I know subscriber can reach and logs are being left at the publisher's IIS.
I have tried many things but I'm coming up blank. Any suggestions?
May 12, 2015 at 6:51 am
Just in case anybody comes here with similar error - it turned out to be a boneheaded mistake of mine...
When I generated the scripts from one machine and applied it to another computer, I forgot to update the @subscriber parameter of the sp_addmergesubscription. Because anonymous subscriptions are disallowed, all subscribers has to be verified with the records created at the publisher via the sp_addmergesubscription. Since @subscriber did not match, no data would be sent and thus error 'no subscription exists/is expired'.
Contrary to the popular myth, sometimes the error message really do say what they are saying!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply