Replication via Web, new subscriptions and snapshots
Hi everybody, I'm quite new to SQL 2005 and I’m trying to understand some key concepts regarding replicas. I need to develop an application with characteristics similar to the Sales Order Sample for Merge Replication, on the client side it should run with the express version of sql server and also the synchronization should only work via web. I try to run the sample but I got an exception in the CreateSubscription method on invoking publisherConn.Connect();
TITLE: Microsoft.SqlServer.ConnectionInfo
Failed to connect to server XXX.
ADDITIONAL INFORMATION:
Login failed for user ''. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
I can’t understandhow this connection could work if it isn’t aware of the fact that it should use https to connect with the server.
Can someone point me in the right direction?
Thanks
Angelo
[2510 byte] By [
Genied] at [2007-12-24]
IF you want to sync over the web via https, then you should spend some time reading these topics in Books Online. This will explain all the moving parts as well as what security needs to be in place. You can start by searching for topic "Web Synchronization for Merge Replication", and go from there.
It looks to me that you are trying to use SQL authentication to the server while it allows only Windows authentication. can you please check that.
Also as Greg pointed out, for Web Synchronization, please do read up the topics mentioned and let us know if you feel the information there is not sufficient or needs improvement.
Actually, I wasn't really interested in the error, I was just pointing out that it sounded strange to me that I had to connect directly to the server because all I want to do was using the web synchronization. In the meantime I investigate further and that's my conclusion. What you cannot do at the moment is register a new subscriber using the web, you need to reach the server directly for this purpose. You can however just sync using an anonimous subscription. The question is: in this scenario is still possible to sync in both directions and the server is still able to just exchange the differences ? Is this is possible then it's fine to me, otherwise I will have to find another solution. Anyway I think there should be a way to subscribe to a publisher using just http(s) protocol. Thanks everybody
I have implemented Web Sync via https only. Yes you are restricted to anonymous pull subscriptions but they are still able to provide bi-directional replication of changes as you requested just like all other forms of merge replication.
This is documented in BOL for anonymous subscriptions which can only connect via https
Cheers
Rab
Thanks, that's really helpfull, so even an anonymous subscription can still get just the differences and not the whole snapshot, and also upload changed data ? So what is the difference with a "named" subscription ? You got this info from BOL of SQL 2005 ? I look at the VS2005 help most of the time.
