locked
Could not establish trust relationship for the SSL/TLS secure channel with authority 'companyuat.dev.com'. ---> System.Net.WebException: RRS feed

  • Question

  • Hi All,

    I am using SharePoint List Connectors to load the data from Sharepoint list to  Sql server.

    I have created an ssis package and attached to the SQL agent job in works fine

    SharePoint Source dev url : http://company.dev.com (working fine)(http)

    DB server:(server\instance)

    I thought all i good and can test with the uat sharepoint url.

    I have changed the configuration url yo point to uat.(https)

    SharePoint Source dev url : https://companyuat.dev.com (working fine)

    DB server:(server\instance)

     

    Suddently it fails when  with the following error:

    In both the cases i am running the agent job from the same db server

    DB server:(server\instance)

     

    Error Message:

    Could not establish trust relationship for the SSL/TLS secure channel with authority 'companyuat.dev.com'. --->  System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure.

    Source: Data Flow Task SharePoint List Source [1] Description: System.ServiceModel.Security.SecurityNegotiationException: Could not establish trust relationship for the SSL/TLS secure channel with authority 'companyuat.dev.com'. ---> System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure.  

    Is there is workaround to reslove this?Any inputs highly appreciated as it is time to move to production :(.

    Thanks

    Ravi


    Ravi

    Saturday, June 14, 2014 8:47 AM

Answers

  • Hi.

    This could solve your issue

    http://www.c-sharpcorner.com/uploadfile/anavijai/could-not-establish-trust-relationship-for-the-ssltls-secure-channel/


    Please remember to click 'Mark as Answer' on the answer if it helps you

    • Marked as answer by Lindali Tuesday, June 17, 2014 2:34 AM
    Saturday, June 14, 2014 9:07 AM

All replies

  • Hi.

    This could solve your issue

    http://www.c-sharpcorner.com/uploadfile/anavijai/could-not-establish-trust-relationship-for-the-ssltls-secure-channel/


    Please remember to click 'Mark as Answer' on the answer if it helps you

    • Marked as answer by Lindali Tuesday, June 17, 2014 2:34 AM
    Saturday, June 14, 2014 9:07 AM
  • I have imported  the sharepoint certificate from the sharepoint server to the SQL agent jobs server. STill no luck

    Thanks

    Ravi


    Ravi


    Wednesday, June 18, 2014 2:53 AM