Configuration Manager-Reporting Services Access Denied When Running R3 Power Management Reports

Ran into an issue at a client this week that I haven’t run into before.  When trying to access the new R3 power management reports, we were receiving an access denied.  The errors we received were the following: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset ‘DataSet2’. (rsErrorExecutingCommand) For more…

Configuration Manager–Configuring SQL Reporting Services (SRS)

Here is a great step by step for configuring and setting up SRS with ConfigMgr: http://blogs.technet.com/b/mwiles/archive/2009/02/19/east-setup-of-srs-with-config-manager-r2.aspx Here is a great article that details setting up the required permissions for SRS: http://scug.dk/blogs/configurationmanager/archive/2009/08/13/configuring-sql-reporting-services-user-permission-for-configuration-manager-2007.aspx Here is the SRS tag on Steve Thompson’s blog, lots of great posts here: http://myitforum.com/cs2/blogs/sthompson/archive/tags/SSRS/default.aspx