SQLTeam.com | Weblogs | Forums

SSIS Web Service task SSL errors

I've tried different credentials, target server versions, etc. hitting our Primavera WSDL.
Works great in any browser.

Via the Web Service SSIS task, I get an error when running the package:

  • Target Server 2016:
    --1. Connection manager "HTTP Connection Manager 1": SSL certificate response obtained from the server was not valid. Cannot process the request.
  • Target Server 2019:
    --2. Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The Web Service threw an error during method execution. The error is: The request was aborted: Could not create SSL/TLS secure channel

If I had to guess, there's a mismatch in TLS version between SQL Server and the Primavera service. I know that later versions of SQL Server do not support TLS 1.1 by default, and I'm not sure 2019 can use it at all.

Not sure if makes a difference, but just told by db/server admin this web service is setup for cookie authentication.