I am currently trying to replicate a SQL Mobile 2005 database with a SQL Server 2005 database through web synchronization using SSL Server AND Client Certificates. On IIS, with "Require Client Certificates" unchecked, I can replicate fine. Once I turn it on, I get a message from replication saying "A Secure Socket Layer connection is required to access this site". I have installed a client certificate in IE, and can access the https://servername/Ojt/sqlcesa30.dll site (I tried removing the client certificate, and I was denied access, then reinstalled it and it worked - so I think that part is working). Does anyone have any experience with this? My production operating environment requires client-side certificates.
Can you make sure you have https:// in your client application and not http://?|||Yes, https works. Like I said, if I'm using only Server certificates, there's no problem - I've turned off non-ssl ports. Also, if I'm looking at the url in the browser with Client certificates turned on, it prompts me for a certificate, and then loads the page fine. But then if I go over to SQL Server management studio and try to synchronize my .sdf, I get the SSL error.|||FYI, I just found this page on MSDN:
http://msdn2.microsoft.com/en-us/library/ms152511.aspx
which says "Web synchronization for merge replication supports using server certificates but not client certificates."
Can anyone verify this? Has anyone ever successfully used a client certificate with merge replication?
|||A server certificate is indeed required for web synchronization, with client certificate it will fail.
No comments:
Post a Comment