Reporting error while accessing from Internet/Sharepoint
Posted on 2009-03-31
I am getting usual SSRS error "unexpected error occurred while connecting to the report server. verify..."
by accessing it over internet, it sometime say timeout error as well in message.
The reports works fine if you refresh it second time. Its only happen next day after overnight cube processing.
I have integrated SSRS and sharepoint 2007 sp1; accessing it over internet successully using FBA authentication.
I have done series of steps to prevent like
-setting "executiontimeout" in website web.config to 3600 seconds.
-turn on detail error flag in web.config like callback=true, custom error=off
seen the log files but could not get the clue of actual error. its only happening in production not on our test environment. not very sure its really a timeout error or something else dropping it.