Proxy Authentication error when calling a webservice from SQL2K stored proc

From: Steve Hebert (steve_at_hebertsoft.com)
Date: 09/16/04 

Date: Thu, 16 Sep 2004 15:01:01 -0500

I'm performing a webservice call from a SQL Server stored proc. Using the
sp_OA... functions, I'm passing data to a COM object (written in C#) and
executing the call to webservice by launching a function on the COM object.

When calling from one box to another, I get an 'HTTP 407 - Proxy
Authentication Required.' error returned from the call to the webservice.
The proxy requirement on the box has been removed, but I'm still gettting
the error when launching the stored proc from within Query Analyzer. When I
browse to the other server, I do not see a 'Proxy Authentication' popup
window.

I'm at a loss for understanding why the error is occurring. Isn't the
stored proc being run under my user credentials? How does that change if
I'm using SQL Server Authentication? Any ideas or suggestions on how to
resolve this one?

Thanks

Relevant Pages

  • Re: Proxy Authentication error when calling a webservice from SQL2K stored proc
    ... It looks like your SQL server is configured to use a proxy for HTTP, ... > the error when launching the stored proc from within Query Analyzer. ... > browse to the other server, I do not see a 'Proxy Authentication' popup ...
    (microsoft.public.sqlserver.programming)
  • handling errors from stored procs
    ... SQL Server 2000 ... comprise the call to a stored proc ... the stored proc gets run...if so, it would be nice if the Access app ... - when stored proc encounters error, it returns that error message ...
    (comp.databases.ms-access)
  • Re: Retrieve error text from extended stored proc
    ... was only on first execution, the following executions, error number was 0. ... However, use OSQL with the -m-1 switch, and you will see that the RAISERROR ... Tibor Karaszi, SQL Server MVP ... > When I call the stored proc from Query Analyzer and force an error, ...
    (microsoft.public.sqlserver.programming)
  • Re: best way to retrieve thousands of records.
    ... I understand you should have a chunky not chatty interface, ... i.e code up another stored proc that accepts ... > retrieve records from sql server. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: best way to retrieve thousands of records.
    ... I understand you should have a chunky not chatty interface, ... i.e code up another stored proc that accepts ... > retrieve records from sql server. ...
    (microsoft.public.dotnet.framework.adonet)
Loading