I spent all day struggling with the above error that poped up on report generation. In the end I found the problem and since I haven't seen this specific issue documented anywhere I figured I share it. This is a new envoronment setup with seperate servers for SSRS and MS SQL. The SSRS logfile complained about "Expired Session" each time. The problem was when the servers were setup they were set to different time zones! The report server (set to Pacific) saw all of the session in the MS SQL Server (Eastern) as expired. I hope this info saves somebody a great deal of time. -- Mark

Hi Mark, Thanks for your post and generous sharing. A report execution time-out value is the maximum number of seconds that report processing can continue before it is stopped. This value is defined at the system level. The report server evaluates the executing time involves both the time caching data into Reportserver database and expression calculating, so you should assure both your database and report server specified in the same time zone, otherwise once the time contrast between them exceeds the execution time-out value, the report execution expired error will always occurs. More information about Setting Time-out Values for Report Execution, please refer to the blow link: http://msdn.microsoft.com/en-us/library/ms155782(v=sql.90).aspx If you have anything unclear, please feel free to let me know. Thanks, Bill Lu Please remember to mark the replies as answers if they help and unmark them if they provide no help.