question

VodaJZ-6840 avatar image
0 Votes"
VodaJZ-6840 asked JudeRenaudin-9788 commented

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"

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
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.

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered JudeRenaudin-9788 commented

Hello @VodaJZ-6840,

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.


image.png (100.7 KiB)
image.png (84.5 KiB)
· 5
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.

@PRADEEPCHEEKATLA-MSFT

Please ignore my last message - I was not aware that there is a difference between my microsoft account username ("tyson-admin") and my windows 10 profile username ("tyson") and i was trying to login using "tyson-admin". i tried it just now with plain "tyson" as username and i was able to connect.

Please can you ensure that the documentation makes it clear that you need to use the profile username and not the account username.

Thanks for the help - your initial response made me think more carefully :)

1 Vote 1 ·

Hello @VodaJZ-6840,

Glad to know that it helped. I will work with the content team to add a note in the document.


If the above answers were helpful, please do click Accept Answer or Up-Vote, which might be beneficial to other community members reading this thread.

0 Votes 0 ·

@PRADEEPCHEEKATLA-MSFT
Thanks for the guidance - I tried these options before but I am getting the same error and I have a couple of questions:

  1. i see that the username in both cases of your screenshots is of the form "XXX@microsoft.com" - is this a valid username on the local machine? it looks like an email address rather than a username.

  2. If my local machine name is "mike" and my local username is "tyson", should i enter (1) "mike\tyson" as username, or (2) "\\mike\tyson", or just (3) "tyson"?

Note that I have also tried the "Azure key vault" option and I am getting the same error, even though the key verification is working fine.
Please advise



0 Votes 0 ·

I
Hi,

 i also tried using emailid of azure account with password , not working for me also.

 Please suggest, if anything is missing.

SHIR is running fine.

0 Votes 0 ·

Thank you this answer is very useful

0 Votes 0 ·
VodaJZ-6840 avatar image
0 Votes"
VodaJZ-6840 answered VodaJZ-6840 published

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>
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.