In SSRS, using Report Builder 3.0 (SSRS R2), after choosing a Report Model as the report's embedded data source, launched "Query Deisinger…" from GUI to build data source in report. First 1-2 attempts at querying underlying data source (Oracle
back-end), are successful, but later attempts freeze application to the point where application freezes and overall Report Builder application needs to be forcibly shut-down.
This system freeze has occurred when referencing tables containing a very small number of records as well as larger data sets. Suspect that application freezing may be caused by timing-out of connection to back-end database. but I am not sure.
Any suggestion to solve this issue?
Environment - Distributed deployment
Server1(report_srv) --Windows server 2003R2 64bit, Installed sql server 2008R2 reporting service, configuration tools
Server2 (report_db_srv) --windows server 2003r2 64bit, sql server 2005 for report server database
View Complete Post