Connect to Azure SQL DB with Private EndPoint in SSMS

Azure sql realsed its private endpoint feature rencetly. In this you can connect to azure sql with private endpoint or private Ip on VNET. For this you should have a S2S or P2S vpn connection. Most of the organisations you will have S2S VPN connection. After creating an azure sql db configure private endpoint.

After that give resource and configuration details as follows:

Here you can go ahead create a private DNS zone for the endpoint or you can only go with Ip and create.

After that open SSMS and give Server Name as IP and in username give adminusername followed by servername with @. Find the screenshot below.

Also check the Trust server certificate checkbox in connection properties.

With this settings you can able to connect to DB with private IP or DNS.

Cheers!!!

Originally published at http://theleadcoder.wordpress.com on March 28, 2020.