Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

One of my clients has a db that contains their data (this server also host an ASP.NET webshop) and they had me write a program for their client which with they can query their db. My problem is that i was advised not to make the SQL server accessible directly through the internet? What would be the standard practice? Should I deploy a VPN client automatically? Im kinda confused on this one. Please advise.

share|improve this question
    
Whether or not the SQL server is accessible directly from the internet is kind of out of your hands and in the hands of the person who manages the router/firewall at the perimeter of the network that the SQL server is behind. –  joeqwerty Oct 31 '12 at 19:32

2 Answers 2

up vote 4 down vote accepted

The standard practice is to not do it.

Either use a VPN / DirectAccess, or use a web service interface.

share|improve this answer
    
yes, that was my initial idea too, but is there a way to deploy a VPN client with the installer of my app? I was thinking about openVPN, but couldn't find anything on how to do that. –  Andris Oct 31 '12 at 20:15
    
Ok, the next one who does not know Windows? Windows HAS INCLUDED CLIENTS for PPTP, IPSEC. Newer Versions even Support other Standards, including MS popietary DirectAccess. There is ZERO Need to deploy a Client if the admin had a clue selecting a VPN Technology. –  TomTom Oct 31 '12 at 20:19
    
@Andris - The problem with deploying a VPN client with your program is that there has to be a VPN server on the other end. Who's going to install, configure and maintain that? What about when network changes require a VPN server and/or client change? This sounds like an untenable solution. –  joeqwerty Oct 31 '12 at 20:23
    
@TomTom, i knew about directaccess, but i think its only available on 7 or higher. –  Andris Oct 31 '12 at 22:30
1  
@Andris pretty much. Program a decent Interface. –  TomTom Nov 1 '12 at 4:59

Between two servers - certificate-based encryption.

Encrypting Connections to SQL Server
http://msdn.microsoft.com/en-us/library/ms189067%28v=sql.105%29.aspx

share|improve this answer

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.