topic Re: Error connecting to Azure SQL server in Dataflow

Error connecting to Azure SQL server

amymc — Tue, 23 Jul 2024 09:37:27 GMT

I am trying to connect to an Azure SQL server using Dataflows, however whenever I try connect i get the error "Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied since Deny Public Network Access is set to Yes" "To connect to this server, use the Private Endpoint from inside your virtual network".

is this a setting i need to change on the SQL server side? Also does this mean I need to access this from a managed private endpoint within Fabric?

Ive seen conflicting points within the documentation whether or not managed private endpoints can be accessed on a trial account

Re: Error connecting to Azure SQL server

NandanHegde — Tue, 23 Jul 2024 13:00:45 GMT

Re: Error connecting to Azure SQL server

Anonymous — Wed, 24 Jul 2024 02:13:18 GMT

Hi amymc ,

Your solution is great, NandanHegde . It worked like a charm! Here I have another idea in mind, and I would like to share it for reference.

You can also check out this topic below for more information on this reported error : Unable to connect to Azure SQL when Deny public network access is enabled - Microsoft Q&A and Azure SQL DB Private Link / Private Endpoint - Connectivity Troubleshooting - Microsoft Community Hub

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.