I received the following error when trying to run a System Centre Configuration Manager 2012 SP1 (SCCM 2012 SP1) report, using SQL Server 2008 R2.
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset ‘DataSet2’. (rsErrorExecutingCommand)
ExecuteReader requires an open and available Connection. The connection’s current state is closed.
Simply reboot the server to clear any files that is kept in memory, causing the reporting server to time-out.
1,456 total views, 3 views today