sql server replication: sqlcesa30.dll unable to access using instantssl or selfsign ssl -- sql server replication

sqlcesa30.dll unable to access using instantssl or selfsign ssl

TheSQLFool
8/14/2007 6:26:01 PM

sql server replication: Hi,

We are tryin to do merge replication between a SQL server standard edition
on a desktop acting as publisher and SQL mobile edition on mobile device
acting as subscriber.

We folllowed the steps in here
http://msdn2.microsoft.com/en-US/library/aa454892.aspx
and everything worked just fine.

Now we need to implement SSL and tried this instantssl
http://www.instantssl.com/ssl-certificate-products/free-ssl-certificate.html
and selfssl http://www.somacon.com/p42.php.

We can access the https://machineName/virtualdir/sqlcesa30.dll via a web
browser but not inside the code.

I suspect its because of the CA is not a trusted authority hence the code
does not work.

Is there a way out without buying an actual ssl cert hopefully?

Re: sqlcesa30.dll unable to access using instantssl or selfsign ssl

Hilary Cotter
8/15/2007 12:00:00 AM

You can use Microsoft Certificate Services to do this, however your clients
will have to be authenticated against the local domain controller.

--
relevantNoise - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]