SSIS Connection manager

Seema Ahire 0 Reputation points
2023-01-25T20:16:46.51+00:00

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

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
2,457 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,860 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,594 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
8,265 questions
{count} votes

3 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 18,896 Reputation points
    2023-01-26T01:37:57.8366667+00:00

    Hi @Seema Ahire

    This article details various causes and provides resolutions for the following errors:

    An existing connection was forcibly closed by the remote host.

    You may take a reference to see if the resolutions could resolve the issue.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    No comments

  2. Limitless Technology 10,251 Reputation points
    2023-01-26T17:03:28.1633333+00:00

    Hi. Thank you for your question and reaching out. I’d be more than happy to help you with your query.

    The 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" usually indicates that there is an issue with the connection between your client and the remote host. Here are a few troubleshooting steps you can try:

    1. Check network connectivity: Make sure that your computer is connected to the network and that you can access other network resources.
    2. Check the remote host availability: Make sure that the remote host is online and responding to requests.
    3. Check the firewall settings: Make sure that your firewall is not blocking the connection. You can temporarily disable the firewall to see if that resolves the issue.
    4. Check the Remote Desktop settings: Make sure that Remote Desktop is enabled on the remote host and that the correct port is being used.
    5. Check the Remote Desktop credentials: Make sure that you are using the correct username and password to connect to the remote host.
    6. Check the Remote Desktop protocol: Make sure that you are using the correct Remote Desktop protocol (RDP) version.
    7. Check the network cable: Make sure the network cable is properly plugged in and not damaged.
    8. Check the router: Make sure the router is functioning properly and not blocking the connection.
    9. Check the DNS settings: Make sure that the DNS settings are correct.
    10. Check if there is a VPN connection: If you are using a VPN, make sure that it is configured correctly and that the connection is stable

    If the issue persists after trying these steps, you may need to contact your network administrator or the remote host administrator for further assistance.

    If the reply was helpful, please don’t forget to upvote or accept as answer, thank you.

    No comments

  3. Yitzhak Khabinsky 20,021 Reputation points
    2023-01-26T17:22:56.24+00:00

    Hi @Seema Ahire,

    I am trying to connect in SSIS for new OLEDB connection

    Please confirm that you are using Microsoft® OLE DB Driver 18 for SQL Server®.

    Provider=MSOLEDBSQL;

    Check it out here: [https://learn.microsoft.com/en-us/archive/blogs/sqlnativeclient/released-microsoft-ole-db-driver-for-sql-server

    No comments