I am SO hoping someone on this forum knows SQL Server replication.
I am setting up Merge Replication via the Web and I get the above error when i try to sync. Let me give you some background.
I wrote a small windows test app to test merge replication, in which i am using RMO to accomplish the replication. This works. It syncs every time.
The subscriber is SQL Server Express, and our need is to have syncronization take place on specified intervals.
To accomplish this, I copied the "sync" code from the winform application and created a Windows Service in which i placed the "sync" code.
The sync code did not change from the winforms app to the Windows Service (and can post the RMO code if necessary).
I have been working with this for a while now trying to figure out why this works (on the same machine) in a winforms app but not through the web (via a windows service).
Any insight would be greatly appreciated.
Author - Professional SQL Server 2005 XML