August 18, 2017 at 3:45 am
Hi,
I am struggling to setup a Web Sync. I have gone thru all the setup and have SUCCESS appearing in my ?Diag page
Problem is with creating the initial Replication. I use RMO, which returns a message to say that the Subscription has been created. However , when it then tries to replicate - I get an error saying that Publication does not exists on Subscriber.
And sure enough if I go looking for in in management studio its not there.
So, then I try to create the subscription manually in management studio, but get an error saying that the Server Version should be higher that subscriber. But it is - My Server is SQL2014 and the subscriber is SQL2008
Any Suggestions gratefully received.
August 21, 2017 at 4:26 pm
David Kilmartin - Friday, August 18, 2017 3:45 AMHi,
I am struggling to setup a Web Sync. I have gone thru all the setup and have SUCCESS appearing in my ?Diag page
Problem is with creating the initial Replication. I use RMO, which returns a message to say that the Subscription has been created. However , when it then tries to replicate - I get an error saying that Publication does not exists on Subscriber.
And sure enough if I go looking for in in management studio its not there.
So, then I try to create the subscription manually in management studio, but get an error saying that the Server Version should be higher that subscriber. But it is - My Server is SQL2014 and the subscriber is SQL2008
Any Suggestions gratefully received.
I've never setup Web Sync for merge replication so don't know much about that. But the errors when using SSMS, for whatever reason it's seeing the versions of everything as not being a supported mix. I've seen that error before. And it's not weird that you didn't get it with RMO as from the testing I have done, the error does not come up with using scripts. So you can script things with a non-supported topology. The supported mixes are listed here:
Suppported SQL Server versions in Replication Topology
Not sure why it sees it that way - did you check the compatibility levels of the databases? I thought with Web Sync for Merge, you still set up a distributor - that could be playing a part.
As for the subscription when you created the subscription, it sounds like it wasn't initialized. Is the subscriber on the latest Service Pack? There are a lot of things to setup to do the sync over the web so you may want to double check all those configurations and the security settings for everything could be the problem:
Configure Web Synchronization
Other than that, you probably need to check your code and look for any errors with any of the pieces that have been setup.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply