Multiple Connections to SQL Database

Hello,

We're in the process of developing a web app in C#/MVC 5 using the Azure infrastructure, with two websites (production and dev) and a SQL database.

The basic structure of the app is that the client will log in to their account and then have access to their data from any device capable of running a browser (tablet, PC, mobile phone etc).

We've made a small test application that talks to the SQL database, however we've discovered that when trying to access the data from another device, we have to keep on setting up new firewall rule to allow the new IP address.

Are there any solutions to get around this, especially since that many ISP here use dynamic IP addresses?

One solution I was advised to use was to setup a VPN and setup a VM running SQL server, is this the way to go?

Regards,

Marc




January 27th, 2014 5:44am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics