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.

I have a question. We develop client-server software using SQL Server on our clients networks. We are wanting to create a web portal that links into this SQL Server database but are unaware of the best practice when it comes to allowing remote SQL Server access.

We know that DMZs are often used for this sort of thing but are wondering what other methods there are?

A little bit of background. The sotware is a desktops app that connects to a SQL Server DB often running on a small business server (but not always). We would like to write a web app in PHP that can connect to each database on the clients newtworks.

Any info most appreciated,

Billy

share|improve this question

1 Answer 1

My own personal preference would be ipsec or Openvpn VPNs, but this might be overkill. OpenVPN tends to be easier to deploy, and works on every version of Windows that I've ever tried.

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.