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.
243 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.
472 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.
328 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Andreas Baumgarten 98,621 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 No 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 No comments