Share via

Connect to an Azure SQL server from Microsoft Fabric

Mcmahon, Amy [GPSIE NON-J&J] 20 Reputation points
2024-07-23T11:07:09.05+00:00

I am trying to connect to an Azure SQL server using Dataflows on Fabric, 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? Has anyone working with Fabric experiences this.

Thanks

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,048 questions
Microsoft Fabric Training
Microsoft Fabric Training
Microsoft Fabric: A Microsoft unified data platform.Training: Instruction to develop new skills.
38 questions
0 comments
Accepted answer
  1. Nandan Hegde 32,996 Reputation points MVP
    2024-07-23T12:22:59.7433333+00:00

    Login to the Azure Portal and the SQL server network settings :

    User's image

    And confirm whether the public network access is enabled for selected network and what is the status of the below property:

    User's image

    It should be enabled for you to access via Dataflow else you would have to use a gateway/vent gateway

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

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