Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old May 15th, 2007, 11:59 AM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Location: Wellington, FL , USA.
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default " Proxy Auto-Configuration Url Not Found" Error

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
========================
Reply With Quote
  #2 (permalink)  
Old May 16th, 2007, 02:24 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Location: Wellington, FL , USA.
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

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

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html
Reply With Quote
  #3 (permalink)  
Old May 23rd, 2007, 02:22 AM
Registered User
 
Join Date: May 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #4 (permalink)  
Old May 29th, 2007, 11:03 AM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Location: Wellington, FL , USA.
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Yep, that's it!

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html
Reply With Quote
  #5 (permalink)  
Old April 28th, 2008, 05:33 AM
Registered User
 
Join Date: Apr 2008
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Reply With Quote
  #6 (permalink)  
Old July 10th, 2008, 06:15 PM
Registered User
 
Join Date: Jul 2008
Location: Cherry Hill, NJ, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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?
Reply With Quote
  #7 (permalink)  
Old August 3rd, 2009, 05:46 AM
Registered User
 
Join Date: Aug 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Not so clear.

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. "
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
PHP Configuration Error? jimmyliew PHP How-To 4 December 16th, 2006 06:32 AM
Proxy class method calls: No error, No data! corin .NET Web Services 0 September 11th, 2006 08:33 PM
Configuration error exstream ASP.NET 2.0 Professional 2 July 2nd, 2006 02:52 AM
Configuration error exstream ASP.NET 2.0 Basics 1 May 6th, 2006 12:39 PM
Configuration Error johno BOOK: ASP.NET Website Programming Problem-Design-Solution 6 July 22nd, 2005 10:07 PM



All times are GMT -4. The time now is 11:24 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.