Can I connect pipeline dataflow to SQL Server on Azure SQL VM

Question

Trying to configure sink of a data flow to SQL Server on an Azure SQL VM.

I assume it can be done as you can configure connections to on-prem SQL.

My DF and SQL VM are both in the same VNET/Resourse Group etc

Cannot use self hosted integration runtime install on the VM as not supported.

Tried the Auto Resolve IR but it cannot connect to SQL VM.

Tried Azure hosted IR in Managed Virtual Network but cannot connect.

Configured Data Factory to use Private Endpoint.

Is there any article or guide to step by step do this?

Answer 1

Hello @PMaguire

Azure Integration Runtime IP addresses

Make sure SQL Server instance is configured to allow connections from the ADF data flow?

Hybrid scenarios

Reference Document, Did you refer this document?
you might need to configure additional settings, such as virtual network peering or private endpoints, to allow the ADF data flow to connect to the SQL Server instance securely.
If the response is helpful, please click "Accept Answer" and Click 'Yes'. So that we can close this thread.