Reporting Service Point – An error has occurred during report processing

Last week I was facing an issue regarding Configuration Manager Reporting Service point which was caused by Allow logon locally group policy restrictions. Bottom-line – make sure the Reporting Services Point account used – has log on locally rights!

Issue
When opening a random report by the Configuration Manager administrative console resulted in the following error: An error has occurred during report processing.

clip_image002

An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot impersonate user for data source ‘AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_’. —> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Log on failed. Ensure the user name and password are correct. —> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors

——————————-
Microsoft.ConfigurationManagement.ManagementProvider.SmsException
An error has occurred during report processing.
Stack Trace:
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters()
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject)
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
——————————-

clip_image004

· Microsoft.Reporting.WinForms.ReportServerException. An error has occurred during report processing. (rsProcessingAborted)
· Microsoft.Reporting.WinForms.ReportServerException. Cannot impersonate user for data source ‘DataSource1’. (rsErrorImpersonatingUser)
· Microsoft.Reporting.WinForms.ReportServerException. Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
· Microsoft.Reporting.WinForms.ReportServerException. Logon failure: the user has not been granted the requested logon type at this computer

When accessing the Configuration Manager Reports directly through Reporting Services Manager URL it ends up in an equivalent error:

clip_image006

Root Cause
As I’m sure the credentials used for the service account are correct I started focusing on the next error which pointed me to the following article: Error Message: The user has not been granted the requested logon type at this computer

This problem typically occurs when the user does not have the permissions to log on locally on the computer. By default, members of the Users group have the ability to log on locally, but an administrator can deny the right to specific user or group accounts. An explicitly denied right always overrides an allowed right.

Further investigation revealed that indeed a GPO was applied which permits – or I my case restricts – log on locally right to specific users accounts.

clip_image007

Solution
By adding the service account used for Reporting Services Point is added as user to the Allow log on locally group policy.

Ensure that the user, or a group the user belongs to the right to log on locally. Ensure that the user, and all groups that the user belongs to, are not denied the right to log on locally.

To assign the user right Allow log on locally

Scenario
This behavior applies to the following Configuration Manager configurations:

· Configuration Manager setup with local SQL Server and SQL Server Reporting Services installed
· Configuration Manager setup with remote SQL Server and SQL Server Reporting Services installed

Background Information
The Reporting Services Point Account is used by SQL Server Reporting Services to retrieve the data for Configuration Manager reports from the site database. The Windows user account and password that you specify are encrypted and stored in the SQL Server Reporting Services database.

Configuring Reporting in Configuration Manager
http://technet.microsoft.com/en-us/library/gg712698.aspx#BKMK_FileInstallationAndSecurity

Technical Reference for Accounts Used in Configuration Manager
http://technet.microsoft.com/en-us/library/hh427337

It's only fair to share...Tweet about this on TwitterShare on LinkedIn1Share on Google+0Share on Facebook0