I have an Azure SQL Database and my clients want to access it. They belong to a place where they are assigned new IP every time whenever they turn on PC/Internet. I have tried to assign a range to access it but they have a huge range gap, for eg to, and If I assign it full range access it will be highly insecure. Please guide me if there are some permissions or solutions I can use for this scenario.

  • Please ask database admin related question on the dedicated DBA sister site of SO!
    – Shadow
    Jun 24, 2022 at 12:18

1 Answer 1


You can set IP address range from which communications are allowed into SQL Database in the Azure SQL Database firewall but for stable IP addresses, this strategy is acceptable.

A firewall security feature called virtual network rules determines whether communications from certain subnets in virtual networks are accepted by the server for your databases and elastic pools in Azure SQL Database.

For dynamic IP addresses to establish and to manage connection from a specific subnet the Virtual Network Rule can be easier substitute.

IP vs. Virtual network firewall rules

virtual network service endpoints and rules

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.