MSDE over VPN issues

[ddrueding]

I can connect to an instance of MSDE using SQL authentication just fine locally, but when I move the server to the other end of a VPN connection, I can't see the server. Any ideas? Google gives me a bunch of junk.

 

[Will Rickards]

Checked port 1433 is open?
Tried by IP instead of name?

 

[ddrueding]

Checked port 1433 is open?
Tried by IP instead of name?

This is inside a VPN, so theoretically every port should be open. Everything else I've tried (RDC, file access, exchange traffic) works absolutely fine. I'm connecting directly from a 192.168.5.4 to a 192.168.0.14, either via IP address or name (a ping by name shows its resolving correctly).

Is there a test where I can specifically test port 1433?

I really appreciate the help, the pressure is on for this one.

 

[Sol]

I usually use telnet to test ports. ie.
telnet 192.168.0.14 1433

If you don't get a connect failed error pretty much straight away then there is something happening on that port...
If you get a connection rejected then it's probably firewalled or something...

It more an art than a science and there is probably a better way but it gives you an idea of where to look...

 

[Will Rickards]

This makes me think somehow the sql server isn't configured to accept remote connections. Have you tried it over a lan? What did you mean by locally, on the same machine or on a different machine on your lan?

 

[Will Rickards]

See this link

 

[ddrueding]

See this link

Great link, thanks Will. I'm heading out to the client now, we'll see how it goes.

 

[ddrueding]

Got it working, thanks for the help.