How do i resolve this error with creating ADF file linked service on self-hosted IR: "Cannot connect to [path]. Detail Message: The system could not find the environment option that was entered"

Voda JZ 26 Reputation points
2021-05-14T20:55:47.907+00:00

i am trying to get data factory going with self-hosted integration server and getting this error when i try to create file linked service

"Cannot connect to [path]. Detail Message: The system could not find the environment option that was entered The system could not find the environment option that was entered."

i searched the communities and found this 'resolution' but it does not work for me:

https://stackoverflow.com/questions/66306691/azure-data-factory-the-system-could-not-find-the-environment-option-that-was-e

Please help

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,603 questions
0 comments No comments
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 77,751 Reputation points Microsoft Employee
    2021-05-17T07:07:58.763+00:00

    Hello @Voda JZ ,

    Welcome to the Microsoft Q&A platform.

    Make sure you are passing the correct username and password.

    • If you want to connect from the local machine, you need to use the same username and password of the local machine.
    • If you are connecting to the domain machine, you need to use the domain username and password.

    Initially I had provided incorrect password and tried to test the connection and got the same error message as shown above: Cannot connect to 'C:\'. Detail Message: The system could not find the environment option that was entered The system could not find the environment option that was entered

    96968-image.png

    Once I provide the correct username and password, I'm able to connect successfully.

    97071-image.png

    For more details, refer Copy data to or from a file system by using Azure Data Factory

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

    ------------

    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.


1 additional answer

Sort by: Most helpful
  1. Voda JZ 26 Reputation points
    2021-05-16T08:21:27.537+00:00

    This is the IR event trace from the windows 10 event log:

    - <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    - <System>
      <Provider Name="Integration Runtime (Self-hosted) Connectors" /> 
      <EventID Qualifiers="0">30000</EventID> 
      <Version>0</Version> 
      <Level>2</Level> 
      <Task>0</Task> 
      <Opcode>0</Opcode> 
      <Keywords>0x80000000000000</Keywords> 
      <TimeCreated SystemTime="2021-05-14T21:45:55.3816923Z" /> 
      <EventRecordID>1754</EventRecordID> 
      <Correlation /> 
      <Execution ProcessID="0" ThreadID="0" /> 
      <Channel>Connectors – Integration Runtime</Channel> 
      <Computer>mweene-p53</Computer> 
      <Security /> 
      </System>
    - <EventData>
      <Data>TraceComponentId: QueryTask TraceMessageId: QueryRuntimeTestConnectionV2Exception @logId: Error FunctionName: TestConnection jobId: 00000000-0000-0000-0000-000000000000 activityId: 3d05a23e-43fc-4347-9150-c37a8e3b781a eventId: QueryRuntimeTestConnectionV2Exception message: TestConnection failed, error message: 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to 'C:\'. Detail Message: The system could not find the environment option that was entered,Source=Microsoft.DataTransfer.ClientLibrary,StackTrace= at Microsoft.DataTransfer.ClientLibrary.AuthorizedOnPremiseFileReader.Logon(Boolean impersonateToAccessRemote) at Microsoft.DataTransfer.Runtime.FileServerValidator.TestConnection() at Microsoft.DataTransfer.TransferTask.InteractiveTaskFactoryV2.ConnectorTestConnection(ConnectionSetting connectionSetting, TestConnectionV2Response response) at Microsoft.DataTransfer.TransferTask.InteractiveTaskFactoryV2.TestConnection(TestConnectionV2Request request, TestConnectionV2Response response) at Microsoft.DataTransfer.TransferTask.InteractiveTask`2.Execute(),''Type=System.ComponentModel.Win32Exception,Message=The system could not find the environment option that was entered,Source=Microsoft.DataTransfer.Common.Windows,StackTrace= at Microsoft.DataTransfer.Common.NativeMethods.WindowsCredentialUtil.GetHandle(String userName, SecureString password, Guid transferId, Guid activityId) at Microsoft.DataTransfer.Common.LogonHelper.Impersonate(UserLogonContext context, String username, SecureString password, Boolean isLocal, Guid transferId, Guid activityId) at Microsoft.DataTransfer.Common.LogonHelper.LogonFileServer(String path, String username, SecureString password, Boolean impersonateToAccessRemote, Guid transferId, Guid activityId) at Microsoft.DataTransfer.ClientLibrary.AuthorizedOnPremiseFileReader.<>c__DisplayClass32_0.<Logon>b__0() at System.Threading.Tasks.Task.Execute(),'.</Data> 
      </EventData>
      </Event>