Connecting Azure Data Factory to Azure SQL Managed Instance

Question

I am trying to connect Azure Data Factory to Azure SQL Managed Instance, but I cannot get it to work. The MI is on a private endpoint, and the Data Factor is on a private endpoint.

I created the Linked Service with a private endpoint:

When I create the dataset, it times out trying to return the list of tables.

I have tried entering the table manually, but same error.

Honestly, this makes no sense. The database I selected in the Linked service has a single table (for testing). And the error isn't very helpful. What am I missing here?

Thank you in advance.

Answer 1

@Scott Klein Thank you for reaching out.

My understanding is that you are trying to connect Azure Data Factory (ADF) to an Azure SQL Managed Instance (MI) through private endpoints.

SQL Managed Instance now has native support for private endpoints. It is recommended creating a private endpoint directly to the SQL Managed Instance resource as described in Managed private endpoints.

This approach simplifies the setup and ensures better compatibility. Make sure to switch to “Proxy” mode instead of “Redirect” when connecting to Azure SQL Database Managed Instance.

Please check the link below for more details.

Tutorial: How to access SQL Managed Instance from Data Factory Managed VNET using Private Endpoint

Please do let us know if you need additional clarification.

Regards,

Oury