In Visual studio 2019, SSIS getting a connection issue for Odata connection.

Srinivas Ravi 0 Reputation points
2023-12-05T11:48:49.25+00:00

Created a Odata connection with parameters like URL, Password, User name etc, and when I check the preview data, I'm able to see the data and when I run the package I'm getting an error like " Cannot acquire a managed connection from the run-time connection Manager." Please help me in resolving this issue

Thanks in advance.

Microsoft Office Online Server
Microsoft Office Online Server
Microsoft on-premises server product that runs Office Online. Previously known as Office Web Apps Server.
611 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,159 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,504 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 34,836 Reputation points
    2023-12-06T01:29:59.9966667+00:00

    Hi @Srinivas Ravi，

    Here is a same issue, you may take a reference to.

    TLS Issue with SSIS package while accessing OData Source like Dynamics AX Online

    We can resolve this using the below steps:

    1. Install Microsoft .NET 4.6 and above on your computer (https://technet.microsoft.com/en-us/library/security/2960358.aspx).
    2. Enforce TLS 1.2 on your machine through registry settings. In an elevated command prompt run the following commands:
    • reg add HKLM\SOFTWARE\Microsoft.NETFramework\v4.0.30319 /v SchUseStrongCrypto /t REG_DWORD /d 1 /reg:64
    • reg add HKLM\SOFTWARE\Microsoft.NETFramework\v4.0.30319 /v SchUseStrongCrypto /t REG_DWORD /d 1 /reg:32

    You may have a try.

    Regards，

    Zoe Hui

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