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

Question

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.

Answer 1

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.