Share via

Configuring Azure Data Factory to Azure SQL VM private (not managed or Azure SQL)

Steven Troccoli 96 Reputation points
2021-07-23T17:35:26.303+00:00

An azure sql VM (not managed or Azure SQL) has a public IP (204.x.x.x) and a private IP (10.0.0.x) in the managed vnet.
Data factory can connect and consume the public IP like any sql server without a fuss.
There doesn't seem to be a way to connect to the private vnet. This documentation for on-prem doesn't seem to work and involves a hop-host in the vnet:
https://learn.microsoft.com/en-us/azure/data-factory/tutorial-managed-virtual-network-on-premise-sql-server
(all that's desired here is for the same functionality that can be yielded by the VM's public IP, but on the private side).

SQL Server on Azure Virtual Machines
Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

Answer accepted by question author

Steven Troccoli 96 Reputation points
2021-07-26T09:39:53.35+00:00

Hi Shaik ;
Not on-prem just a data factory bi-directional to an azure hosted SQL-VM, data flows and pipelines.
For Azure SQL (Non-VM) - the linked services can be made from the subscription. But SQLVMs are not available there.
The current advice seems to be to either add an integration runtime to the VM or do something similar to the on-prem article I mentioned.
Thanks for looking into it.

Was this answer helpful?

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.