SSIS Connection Manager OLEDB Issue

• SP

  SSC Enthusiast

  Points: 173

  More actions

  January 13, 2023 at 8:47 pm

  #4137550

  Hi Team, this is first time I am posting question on forum, I am able to connect to DB using SSMS and windows authentication, however when I am trying to connect in SSIS for new OLEDB connection it seems to give me error as below.

  Test Connection failed because of an error in initializing provider. Client unable to establish connection TCP Provider: An existing connection was forcibly closed by the remote host.

  Please respond. Thanks

  Attachments:

  You must be logged in to view attached files.

• Site Owners

  SSC Guru

  Points: 80332

  More actions

  January 14, 2023 at 9:10 pm

  #4137825

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• CC-597066

  SSCommitted

  Points: 1637

  More actions

  January 24, 2023 at 2:40 am

  #4141039

  I suspect that you are getting an SSL issue. Try changing to a later client e.g. MSOLEDBSQL.

   

• March 10, 2025 at 4:57 am

  This was removed by the editor as SPAM