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,



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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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