Question on Private endpoint for Azure SQL database

anil kumar 1,646 Reputation points
2021-01-29T05:52:37.273+00:00

Hello,

I am new to Azure, please bear with me if my question seems silly.

We know configuring Private endpoint means traffic goes through Azure backbone and internet doesn't come into picture. We don't have VPN or Azure VM and we have configured Private endpoint for Azure SQL instance (just DBs, not managed instance).

I have created a VNET with a subnet with IP range covering my IP address (laptop) and also added private IP assigned to Azure SQL instance in the host file of my laptop but still unable to connect to Azure SQL instance using IP Address.

I think I won't be able to connect to Azure SQL instance using IP address unless I route my connection request either through VPN or some Azure resource.

Appreciate your insightful response. Thank you!!

Azure SQL Database
Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
523 questions
Azure ExpressRoute
Azure ExpressRoute
An Azure service that provides private connections between Azure datacenters and infrastructure, either on premises or in a colocation environment.
391 questions
{count} votes

Accepted answer
  1. SaiKishor-MSFT 17,236 Reputation points
    2021-02-03T07:16:11.743+00:00

    @anil kumar Yes, you need a VPN or Express Route to your VNET from your laptop/on-premise network to be able to connect to your SQL via private link. Here are more details given in the Private Endpoint documentation.
    Please let us know if you need further details and we will be glad to assist you further. Thank you!


0 additional answers

Sort by: Most helpful

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.