2
1
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.
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 – 2012-05-23T06:15:02.230
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 – 2012-05-23T08:29:49.410