I have an Azure SQL database on which my data resides. This data should be retrieved from a system (e.g. Dynamics or another server). However, this system does not have a static IP address. How do I grant these systems access to my Azure SQL database? So far I have only successfully included static IP addresses.
In usually, the dynamic IP address should have the range. If can you get the range IP addresses and then set the dynamic IP range as the firewall rule, the problem could be solved.
In the end, the last solution is that create a fire wall rule from 0.0.0.0-255.255.255.255. For the Security reasons， you can control the database access with user permission.