odbc sql server driver timeout expired

[efinney]

Hi,

Has anyone ever had trouble using the query analyzer tool through a vpn
client? I'm able to connect outside of work to a sqlserver db on my
company lan with enterprise mgr, but the query analyzer times out every
time I try to connect from outside of work. Both utilities work fine at
work (no vpn tunnel).

The exact error is:

Unable to connect to server blahblahblah:
ODBC: Msg 0, Level 16, State 1
[Microsoft][ODBC SQL Server Driver] Timeout expired

I've tried increasing the sqlserver odbc driver's CPTimeout without success.

Appreciate any advice.
Eric

[Simon Hayes]

"efinney" <ef*****@mitre.org> wrote in message
news:cj**********@newslocal.mitre.org...

Hi,

Has anyone ever had trouble using the query analyzer tool through a vpn
client? I'm able to connect outside of work to a sqlserver db on my
company lan with enterprise mgr, but the query analyzer times out every
time I try to connect from outside of work. Both utilities work fine at
work (no vpn tunnel).

The exact error is:

Unable to connect to server blahblahblah:
ODBC: Msg 0, Level 16, State 1
[Microsoft][ODBC SQL Server Driver] Timeout expired

I've tried increasing the sqlserver odbc driver's CPTimeout without
success.

Appreciate any advice.
Eric

Assuming there are no name resolution issues, then you need to make sure the
correct ports are open over the VPN:

http://support.microsoft.com/default...&Product=sql2k

Simon

[Shehzad Shabbir]

Hi Eric

Can you do

Telnet <SQL Server's name or IP address> 1433

If it connects to port 1433 through VPN then it means your connection
is good then you can start diagnosing why you are getting timeouts,
perhaps slow connection or flakey VPN connection.

Regards

Shehzad
efinney <ef*****@mitre.org> wrote in message news:<cj**********@newslocal.mitre.org>...

Hi,

Has anyone ever had trouble using the query analyzer tool through a vpn
client? I'm able to connect outside of work to a sqlserver db on my
company lan with enterprise mgr, but the query analyzer times out every
time I try to connect from outside of work. Both utilities work fine at
work (no vpn tunnel).

The exact error is:

Unable to connect to server blahblahblah:
ODBC: Msg 0, Level 16, State 1
[Microsoft][ODBC SQL Server Driver] Timeout expired

I've tried increasing the sqlserver odbc driver's CPTimeout without success.

Appreciate any advice.
Eric