Error connecting to Azure SQL server

[amymc]

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

[v-yilong-msft · Accepted solution]

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 Hu...

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.

[NandanHegde]

similar issue:

https://learn.microsoft.com/en-us/answers/questions/1836927/connect-to-an-azure-sql-server-from-micr...