up vote 0 down vote favorite
share [g+] share [fb]

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)

link|improve this question
81% accept rate
What happens when you try to telnet to port 1433? – orbitron Jan 27 at 16:57
I should do telnet sqlserverip 1433, right? – Pitto Jan 27 at 16:59
Sounds like a firewall issue to me. – joeqwerty Jan 27 at 17:07
Can you access any other service on that remote VPN host other than pinging it? – Tim Jan 27 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 at 18:44
show 2 more comments
feedback

1 Answer

up vote 0 down vote

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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