I’ve created a Windows-based application (C#, .NET, Windows Forms) which communicates with an SQL database hosted on Azure.

This is all working fine, but the problem is that every time a new installation takes place, I need to add a new opening in the Azure firewall for the new site’s IP address, which is starting to become a pain.

I realise it’s probably a silly question, but is there any way to get the app to communicate with the Azure database without needing to add an exception to the firewall every time there is a new site?

At the moment, I’m forced to create a new rule in the Azure firewall for every new site. It would be nice if there was some way to avoid having to do this.