SCCM 2012 Reports Problem

Kelly Garcia
Kelly Garcia used Ask the Experts™
on
Hi guys,

I am having problem with SCCM reports on my UAT enviroment, on my production it works fine.

When I go into Monitoring > Reporting > Reports - On all the reports I get an error message:

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)

-------------------------------

System.Web.Services.Protocols.SoapException
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


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)

-------------------------------

Please Help
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Check out your Accounts which your using for the reports. It seems that the user or Password is not correct. Also check your Reporting User Service Accounts
Top Expert 2016

Commented:
Check your user accounts and your runas user accounts

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
Kelly GarciaSenior Systems Administrator

Author

Commented:
I am logged in using an administrators account, I am in the SCCM-Admin group on AD, where are the group configurations on AD?
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

Kelly GarciaSenior Systems Administrator

Author

Commented:
sorry guys, I am completely new to SCCM.
Kelly GarciaSenior Systems Administrator

Author

Commented:
I found it ( the security settings ) and its completely the same as my production, I still cant fathom why its not working?
Kelly GarciaSenior Systems Administrator

Author

Commented:
I have noticed when I right click an report and click on edit I am prompted to log in,

log in
this isn't the case in my production environment
Check out the reporting Service configuration...maybe some screenhots
Kelly GarciaSenior Systems Administrator

Author

Commented:
I was thinking of running reg compare with my production environment as it is the same setup, any one know what hives the registry configs are for sccm 2012?
Kelly GarciaSenior Systems Administrator

Author

Commented:
sorted ! the service account was not part of the sql admin group!
Kelly GarciaSenior Systems Administrator

Author

Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for kay07949's comment #a39894906

for the following reason:

The service account was not part of the SQL admin group

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial