Post reply

SSIS error

  • February 5, 2016 at 5:46 am

    #324627

    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

  • February 5, 2016 at 6:01 am

    #1856807

    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?

  • February 5, 2016 at 7:16 am

    #1856831

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

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

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