none
SQL 2012 Merge Replication with Web sync, do not enforce SSL Cert

    Frage

  • Hello,

    Is there a way to just disable, or force using a self-signed cert (basically allow it to use the invalid cert) when using the "Web Synchronization" part of merge replication?

    I'm running that thru an SSH tunnel anyway--

    Is there a buried config setting, registry setting, hack, etc? -- or can you use port 80?

    We do *NOT* want to use a 3rd part cert, or fiddle importing the self signed cert in IE--

    Also do not want to use the UNC or FTP methods.

    Thanks!

    Donnerstag, 14. Februar 2013 19:49

Antworten

  • Are these Compact subscribers?

    Web synchronization replicates data using HTTPS protocol which uses port 443 by default and connections are made using SSL.  SQL Server Compact subscribers can connect over HTTP.

    If you cannot obtain a certificate from a CA then you can use a self-signed SSL certificate using SelSSL utility for testing.  You will need to import the certificate whether it is self-signed or not.  This is covered in Configure IIS 7 for Web Synchronization.  There is no buried config, registry setting, or hack that I am aware of to avoid this.


    Brandon Williams (blog | linkedin)

    Donnerstag, 14. Februar 2013 20:06
    Moderator