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 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)

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

1 Answer 1

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.

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.