Forum Discussion
SSIS OData Connection Manager Error SQL Server 2022
Hi!
I have recently lost the ability to connect with a Service Account (user/password) to a Project Online OData Source:
The version of the OData Connection Manager is 16.100.0.0:
I have enabled TLS 1.2:
reg add HKLM\SOFTWARE\Microsoft\.NET\Framework\v4.0.30319 /v SchUseStrongCrypto /t REG_DWORD /d 1 /reg:64
reg add HKLM\SOFTWARE\Microsoft\.NET\Framework\v4.0.30319 /v SchUseStrongCrypto /t REG_DWORD /d 1 /reg:32
Security Defaults is also disabled in Azure AD:
https://ragavanrajan.medium.com/odata-service-to-sharepoint-error-2b84df8fb7d7
But still cannot authenticate anymore and no clue on what to check next.
Any hint would be much appreciated.
- WoodyCopper Contributor
I wonder how Microsoft has deprecated basic authentication and let the OData Connector in the Integration Services package out of service, breaking all SSIS packages that use OData. Is there any newer version of the OData Connector being released to fix this?
- JamesMc78Copper ContributorHi, did you find a resolution for this? We have a similar error.