Web Service, Unable to Connect to Remote Server

Posted on 2009-02-16
Last Modified: 2013-12-03

I would really appreciate it if someone can assist me with this problem:

I have a Integration Services Project in business Intelligence Studio that uses a Web Service Task to connect to a web service on a different machine. Running the package throws the error

"Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The Web Service threw an error during method execution. The error is: Unable to connect to the remote server."

- I can browse the web service (.asmx) using Internet Explorer
- In setting up the HTTP connection manager in BI studio I CAN click on the "Test connection" tab successfully.
-I am not using "localhost" as a reference but DNSname/Machine name

Any help would be great thanks.
Question by:experts555555

    Author Comment


    Thanks, I'd like  to add that after re-creating the SSIS package I get the following error:

    SSIS package "AutoUpdatePackage.dtsx" starting.
    Error: 0xC002F304 at Call Update Web Service, Web Service Task: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The Web Service threw an error during method execution. The error is: The request failed with HTTP status 502: Proxy Error ( The ISA Server denied the specified Uniform Resource Locator (URL).  )..
       at ...

    something tells me the server the Web Service is located on is blocking something, but why then can I browse the web service via Internet Explorer?

    Accepted Solution

    Hi all,

    I found the solution!!!

    The Call to the web service / SSIS package is dependent on the browser settings of the machine/server the package is running on.

    This is the first time I come across this, it makes sense if you think about it. Before adding proxy settings into Internet explorer i tried adding these  settinginto the HTTP Connection manager, but it didn't work. The only other difference then was the settings of IE which was setup on my local machine, but not on the server I am implementing on.

    Hope this makes sense. Hope someone else can benefit from this.

    Expert Comment


    Expert Comment

    unable to connect to remote server when dragging and dropping a user control in a windows form?
    any idea  hw to solve this isuue?
    LVL 22

    Expert Comment

    For those interested in the subject, take a look at:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now