Long connect times over VPN

[mowog74]

I'm using a VPN connection to develop and administer a SQL server database. When i connect using EM, the login process takes abnormally long (~20-30 seconds). This is only a minor annoyance in EM, but in query analyzer, even though i've set the login timeout to 30 seconds, the login attempt times out after about 15-20 seconds and i can't connect.

So my questions are:
1) Why is it taking so long to connect? (I'd rather answer this question, of course)

and 2) How can i increase QA's connection timeout value, given that the "Login timeout" setting on the connections tab of the options dialog doesn't seem to be having any effect?

Thanks in advance...

 

[mowog74]

Some extra information:
Both server & client are running win2K professional, and SQL version is 2000. VPN is win2k as well. Also, although login times have always been longish and sometimes have taken 2-3 tries for success, only today has it gotten to the point where i could not connect at all in query analyzer.

 

[foxdev]

What protocol are you using on the client side (IOW, what is set as the protocol for connection to that server, or the default, in SQL Server's Client Network Utility)?
Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[mowog74]

I was originally using TCP/IP. Just a little while ago I created a new alias to the same server using named pipes as the protocol (wasn't sure if this would work over the VPN, but it did), which has shortened the login time just enough so that QA will connect without timing out. It still takes a good 10-15 seconds to connect though, so I'd still love to hear any advice on making this quicker... Thanks.