When using an Azure VM or Azure SQL-based database with Jet products, it may occasionally be necessary to explicitly grant access to your data for those within your organization.
This can be accomplished by "whitelisting" your organization's range of IP addresses.
Access your Azure SQL Server
Within the Settings pane, select SQL databases and then select the database to which you want to grant access.
Click Set server firewall
At the top of the Firewall Settings window, click + Add client IP.
Then specify a Rule Name as well as the Start IP and End IP of the address range that needs access to the database