I am SO hoping someone on this forum knows SQL Server replication.

I am setting up Merge Replication via the Web and I get the above error when i try to sync. Let me give you some background.

I wrote a small windows test app to test merge replication, in which i am using RMO to accomplish the replication. This works. It syncs every time.

The subscriber is SQL Server Express, and our need is to have syncronization take place on specified intervals.

To accomplish this, I copied the "sync" code from the winform application and created a Windows Service in which i placed the "sync" code.

The sync code did not change from the winforms app to the Windows Service (and can post the RMO code if necessary).

I have been working with this for a while now trying to figure out why this works (on the same machine) in a winforms app but not through the web (via a windows service).

Any insight would be greatly appreciated.


Thanks...



Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

__________________
========================
Scott Klein
Author of:
Professional SQL Server 2005 XML
Professional WCF Programming: .NET Development with the Windows Communication Foundation
Professional LINQ
========================

Found the answer. It was a security issue...

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

Can you please elaborate on this "security issue" I am having the same problem and cannot find a way to resolve it.
Thank you in advance.

Thuyen

Edit: nm. I found out my problem. I was logged in as Administrator on the subscribing server, thus, having that error.
I logged in as subscriber and ... it worked! such a doofus :P

Yep, that's it!

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

I have encountered this problem.You help me Detailed Explanation on .
Thank you very much!

I am not sure I understand the solution to this issue.

I have a dll that contains all of my RMO code. Like you, when I call this code from a WinForms App, everything works perfectly. However, on some computers when I call this same code from a Windows Service, I get the 'The Proxy Auto-configuration URL was not found' error.

Are you saying that you can't be logged into the subscribing computer as administrator for this work?

Any additional information would be greatly appreciated.

UPDATE: I had installed this Windows Service using the LocalSystem account which has the highest privileges. Interestingly, when I manually edit the service through the Control Panel and assign a user account, everything works.

Does anyone know of any Windows settings that would cause the LocalSystem account to generate the Proxy error?

Hi

I am using windows service, Plus LocalSystem and Its works fine if i run it from command prompt. but each time it runns from windows service. it fails with same error "Message: The Merge Agent could not connect to the URL 'https://......./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. "