question

Ddr-6774 avatar image
0 Votes"
Ddr-6774 asked rdkn-7971 answered

Need help with Odata connection in SSIS - cannot acquire a managed connection

Hello! I am having a problem with Odata connector.
Odata connector is used to pull data from Dynamics Business Central 16.
We use both Odata 4 and Odata 3 versions(version 0.1.11).

Visual Studio 2019, SQL Server Integration Services Projects v 3.10 - running in Visual Studio works just fine. Tried before with Visual Studio 2017 - also works fine.

Deploying to the SQL Server 2014 - running in SSIDB returns error: Cannot acquire a managed connection from the run-time connection manager. [SSIS.Pipeline] Error: OData Source failed validation and returned error code 0xC020801F.

On SQL Server machine we have Microsft Odata Source for SQL Server 2014 component installed for 32 and 64bit, SSDT for VS 2017

We also have TLS settings changed according to https://docs.microsoft.com/en-us/archive/blogs/dataaccesstechnologies/tls-issue-with-ssis-package-while-accessing-odata-source-like-dynamics-ax-online

Also tried: running 32 bit and 64 bit mode.

Nothing helps.

Please advise, what could be the issue here?

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @Ddr-6774 ,

Please check if the user has full permissions to access to the Odata source.

Please refer to OData Source and Tutorial: Using the OData Source.

Best regards,
Mona


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

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Ddr-6774 ,

May I know if you have anything to update?

Best regards,

Mona

0 Votes 0 ·
rdkn-7971 avatar image
0 Votes"
rdkn-7971 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.