Error Code 22853: Access to path on vm is not allowed.

Rizwan Sheik 0 Reputation points
2023-02-15T13:43:43.6166667+00:00

Hello,

I am trying to create a dataset for one of the pipelines in data factory, it is file system type and the host is virtual machine D drive and I am using self hosted integration runtime and while I click on test connection it is throwing the error: connection failed.

Error code22853

DetailsAccess to 'D:\nginx-1.22.1\nginx-1.22.1\logs' is not allowed.

Activity ID: ba7d55d2-66be-4501-8bee-351b7d06f9ae.

Appreciate anyones help.

Thanks in advance.

Screenshot 2023-02-15 191149

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,255 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,708 questions
{count} votes

4 answers

Sort by: Most helpful
  1. RYOMA NAGATA 5 Reputation points MVP
    2023-02-20T22:47:31.9066667+00:00

    The latest SHIR has a security fix that has been changed and does not allow access to local files by default.

    You must run .\dmgcmd.exe -DisableLocalFolderPathValidation to disable the setting.

    https://learn.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime?context=%2Fazure%2Fsynapse-analytics%2Fcontext%2Fcontext&tabs=synapse-analytics#set-up-an-existing-self-hosted-ir-via-local-powershell

    1 person found this answer helpful.
    0 comments No comments

  2. bamidele james 0 Reputation points
    2023-02-17T13:47:00.6166667+00:00

    Am able to resolve this by putting the complete path, the error is a result of the upgrade in the self-integration runtime, in the latest version of IR you need to provide the complete file share path.


  3. RYOMA NAGATA 5 Reputation points MVP
    2023-02-20T22:46:18.88+00:00

    The latest SHIR has a security fix that has been chenged and does not allow access to local files by default.

    You must run .\dmgcmd.exe -DisableLocalFolderPathValidation to disable the setting.

    https://learn.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime?context=%2Fazure%2Fsynapse-analytics%2 Fcontext%2Fcontext&tabs=synapse-analytics#set-up-an-existing-self-hosted-ir-via-local-powershell


  4. PRADEEPCHEEKATLA-MSFT 79,141 Reputation points Microsoft Employee
    2023-05-17T09:27:50.21+00:00

    @Rizwan Sheik - - Thanks for the question and using MS Q&A platform.

    According to the offical documentation, the latest SHIR has a security fix that has been changed and does not allow access to local files by default.

    User's image

    You must run .\dmgcmd.exe -DisableLocalFolderPathValidation to disable the setting for more details, refer to Set up an existing self-hosted IR via local PowerShell

    User's image

    User's image

    Default: Enable security validation to disable access to file system of the local machine.

    Errorcode22853

    After Disabling access to file system of the local machine using: .\dmgcmd.exe -DisableLocalFolderPathValidation able to access the data from linked service.

    Resolve

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.