SSIS connection failing to SQL 2016 server

  • I m trying to make a connection from SSIS using OLEDB for SQL SERVER and SQL Server Native Client but I get an error message when testing the connection 'Test connection failed because of an error in Initializing provider. DBNETLIB connection open(SECDoclientHandshake). SSL Security Error. I tried with win/sql authentication ,  but none of them works. However when I try from mgt studio I am able to connect to that server. Is there anything that needs to be done at server level to get this connection set up? please advise. TIA

  • What (version) of client tools to use to connect?
    is it BIDS? is it Data Tools? (version?)

    Likes to play Chess

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

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