Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 413
  • Last Modified:

connecting sql office network from home computer

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.
Thanks
0
b001
Asked:
b001
  • 3
4 Solutions
 
John HurstBusiness Consultant (Owner)Commented:
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
0
 
NetExpert_plCommented:
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.
0
 
mo_patelCommented:
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
0
 
John HurstBusiness Consultant (Owner)Commented:
@mo_patel  - I think we covered this above.  ... Thinkpads_User
0
 
John HurstBusiness Consultant (Owner)Commented:
@b001 - Thank you and I was happy to help you with this.  .... Thinkpads_User
0

Featured Post

Evaluating UTMs? Here's what you need to know!

Evaluating a UTM appliance and vendor can prove to be an overwhelming exercise.  How can you make sure that you're getting the security that your organization needs without breaking the bank? Check out our UTM Buyer's Guide for more information on what you should be looking for!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now