Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kshahzad
Starting Member
45 Posts |
 Posted - 2013-07-16 : 13:18:48
|
| i am getting connection time out for many ysers[Microsoft][ODBC SQL Server Driver]Timeout expired |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-16 : 14:03:12
|
| 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? |
 |
|
|
|
|
|
[Microsoft][ODBC SQL Server Driver]Timeout expired