When searching for events using the web reports, I sometimes or always get the following error message: [Microsoft][ODBC SQL Server Driver]Timeout expired.

Article ID: 96
Category: Web Reports
Created: 2006-08-25

The web reports have a limit on how long a database query may take before it is interrupted. You can increase this limit through the profile editor however. Navigate to Maintenance - Profile Editor, select your profile, and increase the value Query Timeout in the Database Connection section.

This will however not solve the underlying problem with your database however, which is not able to process queries in a timely manner. This could either be because your database has grown too large, or because the hardware of your database server is insufficient. Please see the additional links below for an article explaining how to optimize performance and for hardware suggestions on your database server.