troubleshooting Question

Proxy Authentication fails for HTTP Connection Manager

Avatar of nicoleheritage
nicoleheritage asked on
Microsoft SQL Server 2005Microsoft Forefront ISA ServerWeb Services
2 Comments1 Solution3394 ViewsLast Modified:
I am creating an SSIS package in visual studio 2005 to do a fairly simple web service task via a script component transform (problems with the web service built in task made me build this as a script component) and I am having problems with it failing due to:

"Error: 0x1 at Data Flow Task, FetchRates: The request failed with HTTP status 407: Proxy Authentication Required ( The ISA Server requires authorization to fulfill the request. Access to the Web Proxy filter is denied.  )."

On my http connection manager that i'm using, i have the server URL as the full HTTP url to the WSDL file, and my proxy url as set to "http://proxy.myserver.com:8080" and all the correct username/password/domain info supplied.  I know this is correct because i used this same proxy info to create the VB wrapper of the WSDL file that i needed for the script component.  Are there any known bugs with VS2005 for the HTTP connection manager??

Also, as a final side note i have tried every variation of the above i can think of (i.e. removing the "http://", removing the ":8080", etc).  Also, i can get the "test connection" button to test successfully.

I really appreciate any help that can be given.  I've been banging my head on this one for a while!
Thanks!!


Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros