Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'd like to be able to make my dev database server accessible over the internet. I and half a dozen dev applications will be the only users. I have a hosting account that includes SQL Server, but I prefer to keep this for staging and production instances.

FYI My set-up at home is an HP ML server with a 60MB (reasonably fast upstream) cable connection to the net. I'm using an Apple Extreme wifi router. I have a sketchy understanding of what's required from doing some preliminary research. Opening ports on the router, perhaps running an SSH server and so on but I'm having some trouble putting it all together in a coherent, reasonably secure architecture and could really do with some pointers.

Thanks in advance.

share|improve this question

migrated from serverfault.com Aug 28 '12 at 5:27

This question came from our site for professional system and network administrators.

    
so is the dev sql server in your home and you want to make it available to YOU ONLY when your outside the home? Not totally clear when you say "I and half a dozen dev applications will be the only users". –  Bret Fisher May 23 '12 at 6:15
    
Sorry I mean I'll be doing ad hoc stuff, data import etc. via Management Studio and I have some dev apps running (inside my home network) that would also be hitting the db server. Nothing else. –  5arx May 23 '12 at 8:29

1 Answer 1

up vote 1 down vote accepted

Without getting into the whole "most secure" debate, the short answer is to think about two things:

  1. Access control. You could use a VPN. I recommend Hamachi which then wouldn't require you to open any firewall ports.
  2. Encryption of communications. Solved by Hamachi as well.

Lots of other ways to do it, but the usual way (old school) would be to open the SQL port on your firewall and connect via IP (or use dyn.com for dynamic DNS name). This isn't near as secure as the Hamachi option.

share|improve this answer
1  
Yeah, Hamachi is to VPN's like join.me is for remote desktop. The easiest possible way to do it. –  djangofan May 23 '12 at 19:25
1  
I installed Hamachi and I haven't looked back. VPN is definitely the way to go esp. when it involves zero-configuration. Thanks very, very, very much for your suggestion. –  5arx May 25 '12 at 11:45

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.