Secure connection to Azure SQL for Remote Desktop Manager
Hello..
I would like to learn something new and in the process hopefully secure a connection to a Azure hosted SQL server and SQL Data store for Remote Desktop Manager.
We recently setup and Azure SQL server for the means of having some of the apps we provide to be "always available"
We use Remote Desktop Manager to connect to our customers and I was tasked with setting up our data store on the new Azure SQL server and to allow our staff access from anywhere - Yup the internet.
I am not crazy enough to simply open port 1433 to the SQL Server over the internet.
So is there a solution or help or a "Schooling" moment someone can provide me in which I can have some form of proxy in between the Azure SQL hosted data source and the internet?
Any information would be greatly appreciated.
Cheers,
Izak
Add support for preshared key for VPN
Does this exist yet, we connect to over 98 sites using the VPN phone book and one decided to start using L2tp with a pre-shared key. Some other customers have already given a heads up on them using MS VPN L2TP with pre-shared keys.