'An existing connection was forcibly closed by the remote host error with Connection Manager

I am trying to connect to db server from ETL servers through SSIS package. Connection is not working from any ETL servers through SSIS. Below is the screenshot. Please let me know what I am missing.

We also performed a test with the telnet client and test was successful.

Error Screenshot

Error Message: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.

ssis


Solution 1:[1]

  • Restart all SQL Server services
  • Check if SQL Server browser is running and SQL Server is configured to allow remote connections.
  • Check your SSL and TLS settings from the registery settings. The settings between the client and server should be logical and consistent (i.e. if the server only allows 1.2 and the client only supports 1.0)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Amira Bedhiafi

Related Questions