Getting error when trying to link to a local CSV file via a tutorial.

Question

I have a laptop with Windows 11 and have signed up to do a tutorial on Udemy to learn Azure Data Factory, which I will now call ADF. I work at home using a VPN to connect to work computers. I'm trying to link a Linked Service to a local file on my laptop.

I'm getting errors when I enter a username and password and host in a new Linked Service that I made. I already used the Quick Install of the Self-Hosted Integrated Runtime on my laptop. I do not know what other permissions I need to set up on my laptop. I also did one command in a cmd.exe window which was c:\Program Files\Microsoft Integration Runtime\5.0\Shared\dmgcmd -rn KEY.

Back to the SHIR, I entered my host (network style path to the local directory on the C: containing the csv file I got from the tutorial), my network username like SERVER\USERNAME, and password. When I click "test connection" I get this error:

"Connection failed. The value of the property '' is invalid: 'Access to my-laptop is denied, resolved IP address is aaa.aaa.aaa.aaa, network type is OnPremise'. Access to my-laptop is denied, resolved IP address is aaa.aaa.aaa.aaa, network type is OnPremise Activity ID: 1a677f10-ee81-4f72-b97b-034c9a7bd649."

I have also rewatched the tutorial several times, found 2 pages on the SHIR, did a search to find solutions and have not fixed the problem yet.

I'm not a network guy and don't know what permissions I need on my laptop to get this running. Was it bad that I used the Quick Install for SHIR?

How do I get my Linked Service in ADF to test correctly?

Thank you!

---

EDIT 8/29 On the Azure end I have allowed my laptop IP through with a firewall rule which allows a range of IPs to account for a dynamic IP address. I don't think I have dynamic IP address when I am at the office but I do when I work from home. This did not work. Our Office network is protected with a VPN so even when I bypass the VPN by going to the office it still does not work.

I'm contacting our IT people to see if they need to allow the Azure IP through our work firewall.

In the SHIR:

1. When I go to the SHIR on my laptop, and go to Settings tab, I see this message in the status bar of the SHIR: "Failed to connect to cloud services with current HTTP Proxy, reconnecting... (Data Factory V2)".
2. I do not see any settings in the SHIR to enter any IP any where. There is no proxy in the SHIR settings either.

Answer 1

Hello @Chuck Roberts ,

Just checking if we are still connected on this discussion? Please let us know if you need to add more info so that we better assist you!

It sounds like you are trying to create a linked service in Azure Data Factory to connect to a local CSV file on your laptop using a self-hosted integration runtime (SHIR). Here are some steps you can take to troubleshoot the issue:

1. Check the SHIR status: Make sure that the SHIR is running and has a status of "Active" in the Azure Data Factory UI. You can also check the logs for the SHIR to see if there are any errors or warnings that might explain why the connection is failing.
2. Check the network settings: Make sure that your laptop is connected to the network and that the network settings are configured correctly. If you are using a VPN to connect to work computers, make sure that the VPN is configured correctly and that you have the necessary permissions to access the local CSV file.
3. Check the credentials: Make sure that you are using the correct username and password to connect to the local CSV file. If you are using a domain account, make sure that you are using the correct domain name and that the account has the necessary permissions to access the file.
4. Check the file path: Make sure that the file path you are using in the linked service is correct and that the file exists in the specified location. If the file is located on a network share, make sure that you have the necessary permissions to access the share.
5. Check the firewall settings: Make sure that the firewall settings on your laptop are configured correctly to allow incoming connections from the SHIR. You may need to add an exception to the firewall to allow incoming connections from the SHIR.
6. Check the SHIR configuration: Make sure that the SHIR is configured correctly to connect to your laptop. You may need to specify the IP address or hostname of your laptop in the SHIR configuration.

If you have checked all of these items and are still experiencing issues, you can contact Microsoft support for further assistance.

Please let me know if you need any help with the support ticket?

Let me know if we can close this case?