Access Azure Server database from azure portal without ip whitelist

Vanessen Munisamy 0 Reputation points
Oct 10, 2024, 12:21 PM

I configure my Azure SQL server, such that Azure services is allowed to access my sql database server. But when login to azure and accessing my db, it is giving me error on ip not whitelisted.

What need to be configured more if I do not want to add ip to whitelist?

The main reason, is that i do not want to add ips everyday or anytime I connect with a different IP.

Azure SQL Database
{count} votes

2 answers

Sort by: Most helpful
  1. Oury Ba-MSFT 19,991 Reputation points Microsoft Employee
    Oct 10, 2024, 4:19 PM

    @Vanessen Munisamy Thank you for reaching out.

    I understand your concern about having to constantly update IP whitelists. To avoid this, you can use Azure Virtual Network (VNet) Service Endpoints. This allows you to securely connect your Azure services to your SQL Database without needing to whitelist IP addresses.

    You can enable "Virtual Network service endpoint" for your SQL Database from the Azure Portal on the networking blade.

    By enabling VNet Service Endpoints, you can ensure that only resources within your specified Virtual Network can access your SQL Database, without needing to manage IP whitelists.

    https://video2.skills-academy.com/en-us/azure/azure-sql/database/network-access-controls-overview?view=azuresql

    Please do let us know if you would like more detailed steps or any additional help with this configuration.

    Regards,

    Oury

    0 comments No comments

  2. RahulRandive 10,066 Reputation points
    Oct 12, 2024, 2:53 AM

    Hi @Vanessen Munisamy

    Just to add, To avoid adding IP addresses to the whitelist for accessing your Azure SQL Database, you can use Azure Private Link. This allows you to connect to your SQL Database via a private endpoint, which provides secure connectivity from your virtual network.

    Here is reference document - https://video2.skills-academy.com/en-us/azure/azure-sql/database/private-endpoint-overview?view=azuresql

    Another easy solution would be, by creating a firewall rule with starting IP addresses set to 0.0.0.0. and end IP address set to be 255.255.255.255. This rule allows all Azure services to access your server. But I believe it is not recommended for a production environment.

    Thank You!

    0 comments No comments

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.