Error in Getting SharePoint online data through SSIS

Question

Hi,

I am using SSDT 2015 and trying to pull SharePoint Online data through oData connection. Providing service account to oData connector in place of personal account due to multifactor authentication. Service account is working as expected. But when going to execute the package locally, getting below error:

[OData Source [25]] Error: Cannot acquire a managed connection from the run-time connection manager.

Please suggest.

Answer 1

Hi @Gangwar, Pradeep Kumar,

Please follow below steps to have a try.

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

Regards，

Zoe Hui

---

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