0

I have a client that using openvpn is connecting to a remote lan where i have a openvpn server (zeroshell) i can use any service without troubles. Now i am trying to connect to a sql server sitting on anoher subnet.

My client --> openvpn server --> router --> sql server

Openvpn server is on lan 192.168.50.x The router connects lan 192.168.50.x to 192.168.60.x

SQL server is on 192.168.60.x My client pings without problems the sql server after being connected to the vpn but i can't set odbc to connect to it.

What is wrong? what should I set?

Ps Client is xp, SQL server is windows 2003, vpn server is linux (zeroshell)

7
  • What happens when you try to telnet to port 1433?
    – orbitron
    Jan 27, 2012 at 16:57
  • I should do telnet sqlserverip 1433, right?
    – Pitto
    Jan 27, 2012 at 16:59
  • Sounds like a firewall issue to me.
    – joeqwerty
    Jan 27, 2012 at 17:07
  • Can you access any other service on that remote VPN host other than pinging it?
    – Tim
    Jan 27, 2012 at 18:26
  • If you're using the standard sql server port then yes you should be able to telnet to it. Routing may not be set up properly on the sql server if it needs to traverse subnets. Can you ping your internal OpenVPN IP from the sql server?
    – orbitron
    Jan 27, 2012 at 18:44

1 Answer 1

0

It turns out that the xp client I've been trying to use had problems.

A fresh install solved everything: Sql server works great with openvpn.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .