Networks

Ask something
Discussion Locked

SQL Server time-out error.

0 helpful
3 replies

by hmalek

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How to improve client's data request from SQL server and how to avoid such errors re-occur every time when other users are also accessing to the same datasource?

3 replies

by aong

Need more information to answer your question.

It could be anything from the server unable to handle the volume of data requested, to a bug in sql server that requires patching up the latest service pack.

Key points to consider are:
1. SQL server version and most recent patch applied.
2. Application's architecture (i.e. client/server, web-based/web-service, etc).
3. Are users accessing it over a WAN or just LAN? if over a WAN please indicate bandwidth.
4. Volume of data requested.

by hmalek

The SQL server time-out error is due to the virus attacks(SQL slammer)which was noticed on 25th Dec.2003. My MIS team has done the SQL patch from Microsoft website and the SQL queries back to normal through out the LAN. Thank you.

This discussion is closed to new replies.