I have an application made in visual studio 2015 with winforms and visual basic which works with a database on a SQL Server 2008 R2 server that is located within the same local network of clients.
I currently want to migrate the database so that it is in the cloud, in Azure itself. I already generated the database without problem and my connection lines in the application were updated pointing to Azure.
However, when executing the application, it sends me an error that my ip publishes from where I try to connect, it does not have permissions to connect and that it checks the azure firewall configuration to add it. After adding it in Azure I can open the application without problems.
My question is: Is there any way I can have a connection to the Azure database, regardless of which ip I'm connecting to? This is because clients do not have a fixed public ip and it is tedious to have to add the new public ip every time it changes.
