Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2766
  • 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
Kay
Asked:
Kay
  • 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
 
KayAuthor 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
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
KayAuthor Commented:
sorry guys, I am completely new to SCCM.
0
 
KayAuthor Commented:
I found it ( the security settings ) and its completely the same as my production, I still cant fathom why its not working?
0
 
KayAuthor 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
 
KayAuthor 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
 
KayAuthor Commented:
sorted ! the service account was not part of the sql admin group!
0
 
KayAuthor 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

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

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