Nilesh Shah

Nilesh Shah

  • 11
  • 54.3k
  • 1.3m

Connecting to Azure SQL from client side windows application

Jun 19 2018 4:35 PM
I have a windows application which is currently accessing database hosted on premises in our office. Some users working remotely from home first connect to our VPN to connect to our local server.
 
Now we want to move local SQL server DB on Azure SQL. but here firewall comes into picture. Currently it is asking to whitelist/allow the IP addresses of all users who want to run this application.
 
Remote working users get new dynamic IP address each time they connect to their interner provider. How can I solve this problem so that remote users can connect to SQL server on Azure. I can't keep enabling new IP addresses each time someone gets a new IP.

Answers (1)