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...
I subscribe to SF forum, but I am not on the forum very much. I am a part-time programmer and I normally rely on the SF expertise for advice. However, I saw this post and thought I add my advice. I currently have a remote SF client app connecting via VPN to the centralize network where I have a WinXP workstation running SQL Server Express 2005 database. Couple of things I did to get this working. First of all, as Trent mention, the easiest and most reliable way to setup VPN is to use a hardware solution. I am using McAfee SG310 Snapgear VPN/Router appliance for handling the VPN connection which is located at the centralize network endpoint with the database server. From my experience it is one of the easiest VPN appliances to setup. Secondly, I assigned a static IP Address to the WinXP workstation running SQL Server Express database. The remote computer running the SF Client app can have a dynamic IP address. From there, when I setup my connection string, I used the static IP address of the SQL Server (i.e. 192.168.10.2\SQLExpress). This solution works great assuming you are using broadband internet for end to end VPN connection and not dial-up.
I hope this was helpful.
Jeff
One other thing, before you setup the connection string and test your connection on the remote computer, make sure you have successfully connected the computer to the centralized network via the VPN connection. Also, the one nice thing about the SnapGear appliance is that it supports Microsoft's VPN.