Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</

• chewychewy

  Hall of Fame

  Points: 3126

  More actions

  November 20, 2014 at 9:18 pm

  #295251

  Hi,

  I encounter this error in my application.

  "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

  I understand the difference between the 2 setting. One is for connection and the other is for query execution.

  Connect Timeout

  CommandTimeout

  Just want to understand that when we hit this error, is related to Connect Timeout

  - whereby the connection cannot be established to the database within x seconds or related to CommandTimeout

  - where by a particular query cannot complete the result by x seconds?

  wish to know so that i know which setting to tweak. thanks

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 21, 2014 at 1:29 am

  #1760022

  Looks like CommandTimeout, not ConnectionTimeout.

  You can either increse the timeout or tune the query and make it complete before the timeout expires (default is 30 seconds).

  -- Gianluca Sartori