Configure VPN for SQL Server 2005-2008


Author
Message
Juan Carlos Pazos
Juan Carlos Pazos
StrataFrame User (310 reputation)StrataFrame User (310 reputation)StrataFrame User (310 reputation)StrataFrame User (310 reputation)StrataFrame User (310 reputation)StrataFrame User (310 reputation)StrataFrame User (310 reputation)StrataFrame User (310 reputation)StrataFrame User (310 reputation)
Group: Forum Members
Posts: 144, Visits: 227
Hi

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

Smile Everything is possible, just keep trying...

Reply
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Juan, there are many different ways to setup VPNs.  There are software VPNs and hardware VPNs.  Before we could tell you what to do, it would require in-depth knowledge of your network and your external IPs.

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. Smile

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search