connecting sql office network from home computer

Posted on 2012-09-03
Last Modified: 2012-09-20
Hi Experts

I have sql on one of the machine in my office and I would like to pick data from that machine when I am at home.
I do have broadband at office with static IP address.
Please explain what else is required to achieve this.
Question by:b001
    LVL 89

    Assisted Solution

    by:John Hurst
    In high level terms, you need to establish a connection between home and office. This is can be done securely using VPN. I use a Cisco Linksys RV0xx router at home and have tunnels to several clients. That part should be fairly straightforward. You may need  a speciallst to assist setting up the tunnel connection.

    Now as to using SQL over such a connection, you may find such a method quite slow (because of constant SQL traffic) and it may be prone to errror (and so corrupting the SQL database) if there is any dropout of VPN or other slowness/error.  

    Using client server databases remotely is often best done with terminal server, or by using a spare PC in the office and connection via Logmein or like application.

    .... Thinkpads_User
    LVL 4

    Assisted Solution

    The best option will be to establish a VPN connection. You have got several options. You could use a Windows server machine with Routing and Remote Access configured. You could define an ipsec or SSL conection on the office router.

    Another option would be a remote desktop connection to the SQL server or another machine.
    LVL 6

    Assisted Solution

    VPN is only option if you want to run local queries on home machine connected to DB on your machine at work

    u can set this up many ways depending what it u have at work.... cisco, TMG, RRAS etc...

    if you happy to log on to your machine it self then u dont need vpn, u can use something like logmein
    LVL 89

    Accepted Solution

    @mo_patel  - I think we covered this above.  ... Thinkpads_User
    LVL 89

    Expert Comment

    by:John Hurst
    @b001 - Thank you and I was happy to help you with this.  .... Thinkpads_User

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Transparency shows that a company is the kind of business that it wants people to think it is.
    As companies replace their old PBX phone systems with Unified IP Communications, many are finding out that legacy applications such as fax do not work well with VoIP. Fortunately, Cloud Faxing provides a cost-effective alternative that works over an…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now