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!
When opening a random report by the Configuration Manager administrative console resulted in the following error: An error has occurred during report processing.
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
An error has occurred during report processing.
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)
· 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:
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.
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.
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
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
Technical Reference for Accounts Used in Configuration Manager