ADFV2, VNET, and Linked Services

0
votes

I have an ADFv2, ADLS Gen2 and SQL Database all configured on a VNET. I'd like to connect from the data factory to the storage account and SQL database however I get a permission error on the data factory (see below).

I know I can stand up an integration runtime to solve the connectivity however, is there any way to configure the linked service to avoid the Virtual machine and IR config yet?

Thanks

ADF Error

1
azure-sql-databaseazure-data-lakeazure-data-factory-2
Hi,does my answer helps you? – Jay Gong
Not really @JayGong - are you saying I dont need an IR when connecting ADFV2 to Blob Storage within a VNET? – Murray Foxcroft
I'm saying that adls need to be granted read permission from ADF since your error indicates permission mismatch,you could check it. Surely,IR is needed! – Jay Gong

1 Answers

0
votes

I'm afraid that the error is not related to the IR,to the Permission instead.

You could refer to this link Service principal authentication to grant permission for your ADF to accessing ADLS. If ADLS is source, the READ permission is needed at least,i think.

enter image description here