Hi,
I am trying to create a Merge Replication through Web synchronization , i used the publish server as distributor and i installed IIS on the same server.
i tried the following URL https://mysite/replisapi.dll from publish server and it was ok. i got the following message: SQL Server WebSync ISAPI.
from the subscriber server i checked the url https://mysite/replisapi.dll too and it was ok too and i got the following message: SQL Server WebSync ISAPI.
I created the publisher and publication and everything is fine , i checked the option to allow web synchronization.
From the subscriber side, i created all settings, i did all the steps like the help online book steps. (i added also a credential for my database and later on added to the proxy (merge replication) under SQL AGENT.
I got the following error in View Synchronization status and when press on start button on this screen:
Date 12/07/2005 2:42:35 PM
Log Job History (myjob)
Step ID 1
Server mysubscribServer
Job Name myjob
Step Name Run agent.
Duration 00:00:37
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
2005-12-07 12:42:38.751 The merge process will restart after waiting 30 second(s)...
Connecting to Subscriber 'mysubscribServer'
2005-12-07 12:43:08.810 The upload message to be sent to Publisher 'MyPublishServer' is being generated
2005-12-07 12:43:08.826 The merge process is using Exchange ID 'ED55DDF7-1E04-4259-91A8-DE64CD08602D' for this web synchronization session.
2005-12-07 12:43:12.107 The proxy auto-configuration script could not be downloaded
2005-12-07 12:43:12.122 Category:NULL
Source: Merge Process
Number: -2147209337
Message: The proxy auto-configuration script could not be downloaded
2005-12-07 12:43:12.122 Category:NULL
Source: Merge Process(Web Sync Client)
Number: -2147024894
Message: The Merge Agent could not connect to the URL 'https://mysite/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.
Please , any help about this error something is missing
Thanks,
Tarek
The proxy auto-configuration script could not be downloaded
DamageTime
Was wondered how you went about installing the certificate, I’ve tried every way I can think of through certificates in MMC and can’t get it to work.
Cheers
Graham
Alireza Naghshbandi
The name of the IIS machine on the certificate and the name you specify on the Merge agent InternetURL should match 100%.
Please ensure that and retry your merge.
Also install the certificate on the Client machine so that it trusts the certificate.
tocyril
I still get "The proxy auto-configuration script could not be downloaded".
The subscriber is a Windows 2003 Server / SQL Server 2005. I tried enabling Enhanced security and adding the site as trusted. I tried disabling enhanced security.
Is there in IPSEC policy I might try
Thanks in advance,
Marnee
Masterbrain
If so on the Internet Explorer-->Tools-->Internet Options-->Connections
Tab-->LAN Settings provide a valid proxy server address and port to connect
to. Also check Bypass proxy server for local addresses if you know that the
proxy is a local server.
If you are not using proxy server uncheck this check box.
If that doesnt solve your problem, then on the Internet
Explorer-->Tools-->Internet Options-->Connections Tab-->LAN Settings uncheck
the Automatically Detect Settings check box and try your merge again.
See if that solves your problem
PDav
Hi i did what you said in your reply but i got another error :
Date 12/13/2005 7:10:08 PM
Log Job History (publishserver-Test2-TestPublication1-subscribserver-Test2- 0)
Step ID 1
Server subscribserver
Job Name publishserver-Test2-TestPublication1-subscribserver-Test2- 0
Step Name Run agent.
Duration 00:00:26
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
-XSTEPID 1
-XSUBSYSTEM Merge
-XSERVER subscribserver
-XCMDLINE 0
-XCancelEventHandle 00000714
2005-12-13 17:10:08.717 Connecting to Subscriber 'subscribserver'
2005-12-13 17:10:08.858 Connecting to Subscriber 'subscribserver'
2005-12-13 17:10:08.904 The upload message to be sent to Publisher 'publishserver' is being generated
2005-12-13 17:10:08.920 The merge process is using Exchange ID '36808A91-675C-44E2-A758-AB6E40204685' for this web synchronization session.
2005-12-13 17:10:26.668 A security error occurred
2005-12-13 17:10:26.683 Category:NULL
Source: Merge Process
Number: -2147209329
Message: A security error occurred
2005-12-13 17:10:26.683 Category:NULL
Source: Merge Process(Web Sync Client)
Number: -2147023888
Message: The Merge Agent could not connect to the URL 'https://mysite/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.
NB:- the publisher and subscriber on different domain.
- the publisher is the distributor also.
Thanks
Tarek
Math23
That's kept me going for a full day what with helpful error messages like 'a security error occurred'.
I suppose it's fairly obvious in some ways, but easy to miss all the same - and I didn't find this anywhere in the MS documentation.
Thanks again
Ed
KiranK
Thanks,
Darrell Young