Forum Discussion

Nandu2520's avatar
Nandu2520
Icon for Helper I rankHelper I
3 years ago
Solved

Unable to see Vnet Gateway name while creating Datasource in Power Service

Dear All,   I was working on the requirement to access the Azure SQL server from Power BI service using Private end point. I have configure virtual machine, private end point and VNET gateway also....
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Nandu2520 ,

     

    In this blog we are going to learn how to resolve Error which is  ''connection was denied since deny public network access is set to Yes'' let's create an SQL Azure database and then configure it with a private endpoint.

    Welcome To TechBrothersIT: Connection was denied since Deny Public Network Access is set to Yes

     

    Best Regards,
    Community Support Team _ Caitlyn

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

     

Nandu2520's avatar
Nandu2520
Icon for Helper I rankHelper I
3 years ago

I could see the On-Premise cluster , but when I tried to connect data source using on-premise cluster, its giving the following error: 

Standard2: 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 (https://docs.microsoft.com/azure/azure-sql/database/connectivity-settings#deny-public-network-access). To connect to this server, use the Private Endpoint from inside your virtual network (https://docs.microsoft.com/azure/sql-database/sql-database-private-endpoint-overview#how-to-set-up-private-link-for-azure-sql-database).