I am getting error message: A security error occurred
Server, Publisher, Distributer same comp. Win 2003, IIS 6, SQL 2005 Standard. Dont have static IP yet, using no-ip service.
Tried security certificate using selfSSL, got error, tried thwart trial certificate valid for 20 days, still gives warning on subscriber. added publisher cert to "Trusted Publishers" & warning stopped on subscriber (tried 3 browsers IE, MozFF, Gogl Chrome all ok). but warning still shows on any other computer.
Diagnostic shows success. https://ace.no-ip.biz/websync/replisapi.dll?diag
Subscriber connects over web, uses Internet connection sharing through another computer on LAN. ()
Detailed Error (Names are similar)
2008-10-16 14:56:25.561 Connecting to Subscriber 'S1'
2008-10-16 14:56:26.168 The upload message to be sent to Publisher 'SERVER\SQL' is being generated
2008-10-16 14:56:26.184 The merge process is using Exchange ID '1D328F93-3ADA-4BED-AD70-9A76A59BA77C' for this web synchronization session.
2008-10-16 14:56:58.322 A security error occurred
2008-10-16 14:56:59.864 Category:NULL
Source: Merge Process
Number: -2147209329
Message: A security error occurred
2008-10-16 14:56:59.864 Category:NULL
Source: Merge Process(Web Sync Client)
Number: -2147010889
Message: The Merge Agent could not connect to the URL 'https://ace.no-ip.biz/websync/replisapi.dll' during Web synchronization. Please verify that the URL, Internet login credentials and proxy server settings are correct and that the Web server is reachable.
I have spent many days strugling. Please help.
I also noticed that, when i logon to subscriber using my username the server url works fine, but when i logon using another windows username, the url shows warning.
-------------------
There is a problem with this website's security certificate.
The security certificate presented by this website was not issued by a trusted certificate authority.
Security certificate problems may indicate an attempt to fool you or intercept any data you send to the server.
We recommend that you close this webpage and do not continue to this website
-------------------
I read somewhere that since sql server uses a service account to logon, the security certificate should be installed in the local computer store.
My certification Authority is Thawte and i am using a trial certificate for which the certification authority is not the default as it normally is but a Test CA. For which they gave me another certificate which needs to be added to Trusted CA.
I added both certificates to all Types of Local Computer stores except Untrusted. But still i get warning on using another username.
How can i stop this warning? or suggest how to generate my own certificate and solve this problem. I don't have a static ip yet which i will get in a few days.
I need some help in solving it.