Share via

Connect to Azure SQL Using IP Address

Handian Sudianto 6,541 Reputation points
2023-04-04T01:55:17.6566667+00:00

Hello, I have private endpoint for my azure sql server, can we connect from on-prem using SSMS to the azure SQL by private IP Address?

Azure SQL Database
0 comments
Answer accepted by question author
  1. Alberto Morillo 35,401 Reputation points MVP Volunteer Moderator
    2023-04-04T03:10:54.39+00:00

    If you created the private endpoint already, you can create a private DNS zone for the endpoint or you can connect using the IP address. When you connect using SSMS instead of the Server Name provide the IP address, choose SQL Server Authentication, on the Login field provide the username@servername. Make a click on the Options button, and make sure there is a checkmark next to "Trust Server Certificate". Finally click on Connect.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dillon Silzer 60,701 Reputation points Volunteer Moderator
    2023-04-04T02:38:15.6233333+00:00

    Hi Handian,

    You can communicate to Azure resources on a private network by utilizing Azure VPN Gateway:

    What is Azure VPN Gateway?

    https://learn.microsoft.com/en-us/azure/vpn-gateway/vpn-gateway-about-vpngateways

    You can either set this up or use NSGs with inbound rules on specified ports for your on-prem Static IP address(es).

    If this is helpful please accept answer.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.