title: SSRS2005 timeout error
body: <p>I've been running around circles the last 2 days, trying to figure a problem in our customers live environment. I figured I might as well post it here, since google gave me very limited information on the error message (5 results to be exact).</p>
  
  <p>The error boils down to a timeout when requesting  a certain report in SSRS2005, when a certain parameter is used. </p>
  
  <p>The deployment scenario is:
  Machine #1 Running reporting services (SQL2005, W2K3, IIS6)
  Machine #2 Running datawarehouse database (SQL2005, W2K3) which is the data source for #1
  Both machines are running on the same vm cluster and LAN.</p>
  
  <p>The report requests a fairly simple SP - lets called it sp(param $a, param $b).
  When requested with param $a filled, it executes correctly. When using param $b, it times out after the global timeout periode has passed. </p>
  
  <p>If I run the stored procedure  with param $b directly from sql management studio on #2, it returns the results perfectly fine (within 3-4s). </p>
  
  <p>I've profiled the datawarehouse database on #2 and when param $b is used, the query from the reporting service to the database, never reaches #2.</p>
  
  <p>The error message that I get upon timeout, when using param $b, when invoking the report directly from SSRS web interface is:</p>
  
  <p>"An error has occurred during report processing.
  <strong>Cannot read the next data row for the data set DataSet.</strong>
  A severe error occurred on the current command. The results, if any, should be discarded. Operation cancelled by user."</p>
  
  <p>The ExecutionLog for the SSRS does give me much information besides the error message rsProcessingAborted</p>
  
  <p>I'm running out of ideas of how to nail this problem. So I would greatly appreciate any comments, suggestions or ideas.</p>
  
  <p>Thanks in advance!</p>