SEO

#1 (**permalink**) 02-29-2008, 04:27 AM

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

#2 (**permalink**) 02-29-2008, 04:28 AM

"efinney" <efinney@mitre.org> wrote in message
news:cjvgck$a1f$1@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

#3 (**permalink**) 02-29-2008, 04:28 AM

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 <efinney@mitre.org> wrote in message news:<cjvgck$a1f$1@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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

odbc sql server driver timeout expired