Groups | Blog | Home
all groups > sql server replication > april 2006 >

sql server replication : Web merge replication over proxy server


Pavel Odstrcil
4/7/2006 4:15:01 AM
Hi,

I've setup web merge replication, but I've problem when the subscriber is
behind proxy and the user running replication is not Administrator on the
subscrier machine. When the user is in the Administrator group,
synchronization works ok without additional steps. But when the user is not
in the Adminsitrator group, call to <MergeSynchronizationAgent>.Synchronize()
fails with:

The Merge Agent could not connect to the URL
'https://xxx.xxx.cz/ISAPI/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.

Then I've set InternetProxyUser, InternetProxyPassword and
InternetProxyServer, but the replication still fails, the message depends on
the InternetProxyServer value

The proxy is: proxy.server.cz:8080, it is set in the IE connection.

When I set the InternetProxyServer to, the result is:

- proxy.server.cz
: A connection with the server could not be established

- http://proxy.server.cz:8080/
: The parameter is incorrect.

- http://proxy.server.cz:8080
: The Merge Agent could not connect to the URL
'https://xxx.xxx.cz/ISAPI/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.

- proxy.server.cz:8080
: The Merge Agent could not connect to the URL
'https://xxx.xxx.cz/ISAPI/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've tried IP addres in place of proxy name, to, but no change.

Does anyone know, how to resolve this problem?

Thanks,
Pavel
Pavel Odstrcil
4/7/2006 4:57:01 AM
The other message in ComErrorCollection is... [407 - ISA requires
authorization]

but the properties InternetProxyUser and InternetProxyPassword are set.

Pavel Odstrcil
4/7/2006 5:52:01 AM
Is it possible, that the MergeSubscriptionAgent supports only Basic
authentication on the proxy server when using InternetProxyServer /
InternetProxyUser / InternetProxyPassword properties?

PS. I know, that it supports only basic schema on the target web host and
this is not the problem.

AddThis Social Bookmark Button