Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We've got a MS Small Business Server hosting our Exchange and SQL. Our timesheet system makes use of SQL server, but when we connect to client sites using any form of VPN we can no longer connect to the local SQL server.

I'm no network/server specialist so I'm hoping someone can point me in the right direction.

Regards, Jacques

share|improve this question
Can you connect to any local resources after making the VPN connection? – dsolimano Aug 16 '12 at 15:45
I can connect to the actual server. Exchange for example is still accessible it seems. And file share still works on that server, it's primarily SQL that we can't connect to with our timesheet application. – Jacques Aug 17 '12 at 7:02
up vote 1 down vote accepted

Your SQL server is not accessible from your VPN subnet. This could be for any number of reasons, including that it's designed this way for security purposes.

share|improve this answer
So what could I possible check to see how this is setup? – Jacques Aug 17 '12 at 7:03
@Jacques You mention you can connect to the actual server, but not SQL, which means it's probably a firewall rule. – HopelessN00b Aug 17 '12 at 11:12
I don't know how to explain this, but today I'm not getting the issue at all. This is the first time that I don't have the issue. I've been able to work on the VPN all day and our timesheet application had no problem accessing our SQL server. I'm a bit lost for an explanation because we didn't change anything – Jacques Aug 17 '12 at 15:42
@Jacques The only thing I can think of (other than "huh, weird") is that there could be an IP address conflict on your network if your VPN is not setup to use a different subnet or address pool. It's possible this is created when you connect to a client network, but that wouldn't explain why you could access one protocol and not the other over VPN the other day, and access both today. I'd give your network guy a hard time about it. :) – HopelessN00b Aug 17 '12 at 15:59
We're still having issues. I've been reading more and more and many people mention split tunneling and so on, but these things are above my pay grade! Have no idea how to solve it. We're having the same issues now with our home users logging into our work VPN – Jacques Jun 4 '13 at 12:13

Your Answer


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.