We have a hosted server with a new provider and we also opted for a firewall which is a Cisco ASA 5505. It turns out that they do not provide assistance with the firewall, so I have come here!
The server hosts multiple customer websites, along with both MySQL and SQL Server databases.
I would like to provide customers with the ability to connect to their databases remotely, for which I assume we need to create a VPN to allow them access through the firewall. Also, I would want them to be able to use the standard Windows connection tool(s).
Unfortunately, I know very little about this so I am looking for idiot-proof help ;-)
First of all, is this a safe thing to do - can I control what they can access on the server end? i.e. database access only.
What type of VPN do I need? I looked at one of the wizards and stopped at the point when it started talking about IP addresses ... what range should I / can I use? How does that relate to our server setup, or doesn't it?
I don't know what else to ask ... hopefully someone can guide me in the right direction!