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

• JayK

  SSCrazy

  Points: 2679

  More actions

  March 7, 2011 at 4:57 pm

  #236235

  |Hi,

  We have a series of reports that run on our reporting server but lately we have been getting the

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

  which cause the reports to fail.

  All parameters are set using an XML file. The SQL that is timing out is contained

  The config file contains the line:

  <add key="XXXXXXXXXXX" value="Server=XXXXXXXXX;Database=XXXXXXXXXXXX;User ID=XXXXXXXXXXXXXX;Password=XXXXXXXXXXXX;Trusted_Connection=False;" />

  I am just wondering it it is possible to set the timeout paramter in this string?

  Cheers!

• luckysql.kinda

  SSCertifiable

  Points: 7816

  More actions

  March 7, 2011 at 6:29 pm

  #1295664

  Tweak the query timeout

• Anathn

  SSC Enthusiast

  Points: 107

  More actions

  March 8, 2011 at 8:38 am

  #1295919

  I believe you can only set the connection timeout in the connection string but here is a link on how to set various timeouts on a report-level.

  Setting Time-out Values for SSRS

  Nathan

  http://www.harmonyutilities.com/[/url]