I'm debugging an issue with executing a ssis package. This package calls out to a HTTPS service to download data and load it into a SQL table. Connections made using HTTP connection from a script task with basic security.
SSIS = server A
SQL = server B
HTTPS = server C
Management = server D
Server C is on a third-party domain. Server A, B, D are all on the same domain.
For debugging purposes I'm running the package in the SSISDB from SSMS.
The package runs okay from server A.
When the package is executed remotely from Server D the package fails with
System.Runtime.InteropServices.COMException (0xC001600C): Server authentication failed. This error occurs when login credentials are not provided, or the credentials are incorrect.
I don't believe this is related to Kerberos as we're not using Windows Security.
Looking at a network trace I can see the HTTP request going out to the HTTP service and connections coming back for both executions from server A/B. Although, for server A there are many more TCP frames coming back as data is returned.
SSIS is being run with a local user account.
We have a firewall to get through but no proxy. Port 80/443 is blocked except for exceptions - the URL in the HTTP call is an exception.
Any ideas of how to troubleshoot this?