Merge replication over SSL

Hi All.

Hope you can shed some light on this for me. We have set up a merge replication between a SQL Compact SDF database and a SQL 2005 server located in a different domain , the communication is over SSL. If I sync the subscription from the SQl Server 2005 Management Consol the sync works fine however if I try sync from my application the sync fails.

Thanks in advance

Scott McKechnie

Scott, without wanting to sound unhelpful there really isn't enough information here for anyone to help you out (other than to point you at the documentation, which I'm assuming you already have). Can you please provide more information about the error that is being thrown and the configuration you have setup (for example is the SSL cert selfsigned, can you reach the sync url (http://<server>/<virtualdir>/sqlcesa30.dll) etc)

|||Hi,

I think we have a similar problem here. We are trying to perform merge replication between a MS SQL 2005 server and a Mobile Edition database over SSL.

We get an exception "A request to send data to the computer running IIS has failed" when we tried to perform replication via my mobile application.

However, when I tried to access the sqlcesa30.dll via a browser on the device, we encountered no problem.

Is there some code we have to write which we are missing? I am asking this because we started off writing our mobile application with no SSL in mind. So what we have for the replication object parameters are only as follows:

_repl.InternetUrl = @."https://xxx/mobypub/sqlcesa30.dll";

_repl.Publisher = @."xxx";
_repl.PublisherDatabase = @."mobiDB";
_repl.PublisherSecurityMode = SecurityType.NTAuthentication;
_repl.Publication = @."mobiPub";
_repl.Subscriber = @."mobiPub";

What could be causing the problem? Please enlighten. Thanks a lot.