How can I connect to a private endpoint?

Ashutosh Sharma 81 Reputation points
2022-03-10T08:55:26.93+00:00

I have a DB running which is configured with a private endpoint, how can i connect to the Db using that private endpoint?

Azure Bastion
Azure Bastion
An Azure service that provides private and fully managed Remote Desktop Protocol (RDP) and Secure Shell (SSH) access to virtual machines.
242 questions
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.
469 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.
323 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Baumgarten 97,076 Reputation points MVP
    2022-03-10T09:17:54.98+00:00

    Hi @Ashutosh Sharma ,

    please take a look here: https://learn.microsoft.com/en-us/azure/azure-sql/database/private-endpoint-overview#check-connectivity-using-sql-server-management-studio-ssms

    Important:

    Use the Fully Qualified Domain Name (FQDN) of the server in connection strings for your clients (<server>.database.windows.net).
    Any login attempts made directly to the IP address or using the private link FQDN (<server>.privatelink.database.windows.net) shall fail.

    ----------

    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

    Regards
    Andreas Baumgarten

    0 comments
  2. Anonymous
    2022-09-15T23:24:52.137+00:00

    Beware of the following message that appears to be in conflict. (From SSMS).

    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://learn.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://learn.microsoft.com/azure/sql-database/sql-database-private-endpoint-overview#how-to-set-up-private-link-for-azure-sql-database). (.Net SqlClient Data Provider)

    In this case, if the client is actually within the virtual network, there may be an issue with DNS resolution for that particular client. Even if it has been restarted. A proof would be to launch a fresh VM untainted by other software, or short circuit DNS with a hosts file entry, which should never be necessary. But investigate the DNS issue.

    0 comments