Sql-server – How To Set Up Web Synchronisation With IIS 7.5

merge-replicationsql server

I set up merge replication web sync using a pull subscription.

When I try to start the merge agent at the client side I get this error,

The Merge Agent could not connect to the URL 
'http://address.com/MergeReplication/replisapi.dll' during Web synchronisation.
Please verify that the URL, Internet login credentials and proxy server settings are 
correct and that the Web server is reachable.

When I browse to the address http://address.com/MergeReplication/replisapi.dll?diag it works fine when I specify the same login credentials as I did for the subscription.

If we have a think about some of the possible causes, proxy server, we're not using that. URL is fine (as far as I can tell). Login credentials are OK as far as I can tell too.

The other thing I noticed is that I can see the https traffic in fiddler when I put the ?diag address in my browser, but when I start the merge agent I don't see the traffic in fiddler.

UPDATE:

I used wireshark to look at the traffic going between my subscription PC, and the IIS server. When I run the subscription agent I get this traffic,

TLSv1 Client Hello
TLSv1 Server Hello
TLSv1 Client Key Exchange
TLSv1 Change Cipher Spec, Encrypted Handshake Message
TCP https [FIN, ACK]
TCP https [RST, ACK]

The last item there RST is hilighted as red, and does not appear when I browse to the ?diag page.

Perhaps there is a problem with the certificate I have. I created a self signed security certificate and installed it on my PC. When I browse to the ?diag page I don't get a security certificate error.

Best Answer

The answer at this point appears to be quite simple. I was using a different domain account to run the subscription agent. I had to log into my machine with that account and install the security certificate.