Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Timeout problem when connecting from Vista clients to SQL ..

 
   Database Forums (Home) -> Connect RSS
Next:  Moving from sql2005 standalone to sql2005 cluster  
Author Message
karensundq

External


Since: Jul 06, 2005
Posts: 1



(Msg. 1) Posted: Wed Feb 13, 2008 1:48 am
Post subject: Timeout problem when connecting from Vista clients to SQL Server
Archived from groups: microsoft>public>sqlserver>connect (more info?)

I had a problem connecting from a Vista machine to a SQL Server 7.0
machine. The server and client were separated by a couple of routers.

The client could connect to the sql server but any queries returning
more than about 10 rows would time out.

Also when I tried to use remote desktop to connect from this client to
the same server, it would often lose its connection.

The solution was to turn off a new networking feature of Vista:
"Receive window auto-tuning"

The fix is described here:
http://support.microsoft.com/kb/934430

and a discussion of the root cause if here.
http://blogs.msdn.com/wndp/archive/2007/07/05/receive-window-auto-tuni...on-vist

Just thought I'd share it with anyone having the same problem.

 >> Stay informed about: Timeout problem when connecting from Vista clients to SQL .. 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> Connect All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]