August 12, 2015 at 4:32 am
Hi Team,
I uploaded a rdl file from SSRS 2005 to SSRS 2008.
I am getting this error on viewing it:
An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError)
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Report works fine when I view it via BIDS 2008.
Any pointers on this would be useful.
August 12, 2015 at 11:44 am
Did you increase the timeout on the report?
August 13, 2015 at 9:17 am
I resolved this by setting the Memory to 61440 in the SQL server where my reportserver is hosted.
By default when SQL server is installed, the Max memory is set to a large value (something like 21440000.... ). I changed this to 61440.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply