SSIS error

  • Hi,

    Integration: Error at server : XYZ. The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

    The sample URL used is :

    https://teamspace.abc.com/sites/LLL/LLL-SAP/SARNew/Archive/_vti_bin/listdata.svc

    We access the Url with username and password . I logged in to the server and was able to login with the UserName and password. But not sure why I receive the error when I run the SSIS package through SQL agent job.

    Thanks,

    PSB

  • PSB (2/5/2016)


    Hi,

    Integration: Error at server : XYZ. The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

    The sample URL used is :

    https://teamspace.abc.com/sites/LLL/LLL-SAP/SARNew/Archive/_vti_bin/listdata.svc

    We access the Url with username and password . I logged in to the server and was able to login with the UserName and password. But not sure why I receive the error when I run the SSIS package through SQL agent job.

    Thanks,

    PSB

    Presumably because the SQL Agent job did not use the same username and password?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • The user is an AD user and not a sql user .

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply