Share via

connecting to azure sql db from on prem when Deny public access is set to YES

meroazure1244 101 Reputation points
2022-03-03T21:34:34.517+00:00

Hi,
I have setup azure sql db, virtual network and private endpoint and deny public access is set to YES. I am able to connect to sql db from VM with out issue. What do I need to do if I want to connect to that azure sql db from on-prem. I have SSMS and trying to connect to azure sql db but not able to connect on prem. We do have express route setup .

Azure SQL Database
0 comments
Accepted answer
  1. Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
    2022-03-03T22:16:56.543+00:00

    When you create a Private Link this endpoint is a private endpoint within a specific VNet and Subnet. If you try to connect outside this VNet and Subnet the connection will be using the public endpoint. All connections via public endpoints will be denied with an error message 47073.

    On-Premises users need to access the Azure SQL Database through Express Route Private Peering or VPN.

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.