SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 [Microsoft][ODBC SQL Server Driver]Timeout expired
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kshahzad
Starting Member

45 Posts

Posted - 07/16/2013 :  13:18:48  Show Profile  Reply with Quote
i am getting connection time out for many ysers

[Microsoft][ODBC SQL Server Driver]Timeout expired

James K
Flowing Fount of Yak Knowledge

3554 Posts

Posted - 07/16/2013 :  14:03:12  Show Profile  Reply with Quote
It could be because the network connection from those users to the database server is not available (perhaps temporarily), or the network is slow. It also could be because the queries you are running against the server are taking longer than the timeout set (or default timeout if none has been set).

How long does the query take normally? If it was close to 15 seconds or 30 seconds (I don't recall which), it could be the latter. If queries run very quickly for those users that are able to run, it could be the network. Are you able to ping the database server from those client machines?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000