I read in some post here in SF that is posible use a VPN for connecting to SQL Server.
I actually have LogMeIn for conneting remotly to my computer, but I want to try to configure a VPN for connect from my laptop to a home computer to run a SF application that I have in both, the home computer has a SQL Server 2008 databases that I wish to connect to the database in the home computer using a VPN.
So the question is How to configure a VPN for do this task?
Please, as much detail as you can? I really don't have any idea of how to do this. All what I can do is with LogMeIn using a simple Access database file, which I can share so it's easy to connect to that file. But my main application has a lot of features including SF security that can not put in the Access file.
Kindest regards Everything is possible, just keep trying...
If you do not have static IPs at both ends, then you can use a software VPN on your home or client machine to connect back to a centralized server. If you have no static IPs at either location, then you will have to have an online application to which both endpoints register...this gets really messy. The best solution is to have a static IP at both locations, but at a minimum, at the centralized location. You can then get a router setup like a LinkSys RV042 (a cheap alternative to a PIX or ASA router) that supports IPSEC VPN tunnels. This would reside on the side that has a static IP and would also protect your network. This router also has the ability to support a software IPSEC VPN tunnel coming in. This would allow the second location to have a roaming or dynamic IP.
Like I said, people do this one thing alone for a living meaning there are a lot of ways to go about setting up a VPN. But it is also something that is more difficult to do without exact information as well. Hope this helps get you going in the right direction.