Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aman77
Starting Member
3 Posts |
 Posted - 2008-10-16 : 11:55:28
|
I am getting error message: A security error occurredServer, 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?diagSubscriber 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 generated2008-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 occurred2008-10-16 14:56:59.864 Category:NULLSource: Merge ProcessNumber: -2147209329Message: A security error occurred2008-10-16 14:56:59.864 Category:NULLSource: Merge Process(Web Sync Client)Number: -2147010889Message: 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 websiteI 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 also noticed same error reported by Ken Blum in the following post.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=107445But i need some help in solving it. |
|
|
aman77
Starting Member
3 Posts |
Posted - 2008-10-25 : 15:10:10
|
| Yes it is working now ! The problem was with the SSL certificate. The security warning should not appear at all.I followed the following steps (for the benefit of any newbies suffering like me)I got a static ip from my ISP. Bought and linked a new domain name with my static IP by following the instructions for creating your own DSL web server here : http://www.dslwebserver.com/main/fr_index.html?/main/5-7-adapter.htmlThen i got a trial SSL security certificate from here www.instantssl.com who sent a verification mail to the email address in my domain WHOIS record. And i got going in a few hours. |
 |
|
|
|
|
|
|
|
Merge Replication Web Sync: Security Error