Error: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.


Error: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Description: There can be many reason.

  1. The request to SQL Server or query is taking a long time to execute.
  2. The result is returning large amount of records.
  3. Slow network connection issue.
  4. SQL Command connection timeout is not configured properly.
  5. Badly made SQL statements

Solution:

  1. Check the network connectivity is up and running.
  2. Check the SQL Statements, if required tuned and optimize it.
  3. Check the result size.
  4. Configure Connection Timeout property, by default it’s 15 seconds.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s