Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2864
  • Last Modified:

SCCM 2012 Reports Problem

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
0
Kelly Garcia
Asked:
Kelly Garcia
  • 7
  • 2
1 Solution
 
merowingerCommented:
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
0
 
David Johnson, CD, MVPOwnerCommented:
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
0
 
Kelly GarciaSenior Systems AdministratorAuthor 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?
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
Kelly GarciaSenior Systems AdministratorAuthor Commented:
sorry guys, I am completely new to SCCM.
0
 
Kelly GarciaSenior Systems AdministratorAuthor Commented:
I found it ( the security settings ) and its completely the same as my production, I still cant fathom why its not working?
0
 
Kelly GarciaSenior Systems AdministratorAuthor 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
0
 
merowingerCommented:
Check out the reporting Service configuration...maybe some screenhots
0
 
Kelly GarciaSenior Systems AdministratorAuthor 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?
0
 
Kelly GarciaSenior Systems AdministratorAuthor Commented:
sorted ! the service account was not part of the sql admin group!
0
 
Kelly GarciaSenior Systems AdministratorAuthor 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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

  • 7
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now