Forum Discussion

Woody's avatar
Woody
Copper Contributor
Jul 08, 2023

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:

OfficeDocs-Support/Microsoft365/enterprise/project-online/cant-connect-project-online-odata-from-ssis.md at public · MicrosoftDocs/OfficeDocs-Support · GitHub

 

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://learn.microsoft.com/en-us/answers/questions/516023/authentication-issue-with-project-odata-in-connect

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.

 

  • Woody's avatar
    Woody
    Copper 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?

  • JamesMc78's avatar
    JamesMc78
    Copper Contributor
    Hi, did you find a resolution for this? We have a similar error.

Resources