Data Factory Integration Runtime Nodes in different networks

Question

Hello
I have am trying to set up Data Factory between the on premise SQL Server on a corporate network and a SQL Server hosted in an Azure VM (not MI).
Is this possible? I set up both nodes on the IR and opened firewall port 8060 both on premise and in the Azure VM.

My goal is to copy data as needed from the on premise sql server to the sql server hosted in the azure vm.

I am getting this error

This node has some connectivity issue with the dispatcher node. Please check the connectivity between the nodes within your network.
The Integration Runtime (Self-hosted) node is trying to sync the credentials across nodes. It may take several minutes.
If this warning appears for over 10 minutes, please check the connectivity with Dispatcher node.

Answer 1

Hi @Natarshia Peck ,

Welcome to Microsoft Q&A forum and thanks for your query.

Could you please check and confirm if both the nodes have same version of Integration Runtime installed? If not please uninstall them and install the latest version of the IR from https://www.microsoft.com/en-us/download/details.aspx?id=39717

Additional info:
Since you are setting up multiple nodes, then you need to make sure they can connect each other through port 8060. It depends on how your network configured. They could be accessible by default in many cases, but also could be restricted in some corporate environment. In most cases you at least need to enable port 8060 for inbound TCP in Windows firewall.

Let us know how it goes.