SSIS connection failing to SQL 2016 server

• ishaan99

  SSCertifiable

  Points: 6261

  More actions

  September 28, 2018 at 10:38 am

  #377832

  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

• VoldemarG

  Hall of Fame

  Points: 3883

  More actions

  October 3, 2018 at 12:50 pm

  #2007930

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

  Likes to play Chess