Kelly Garcia
asked on
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.ReportingService s.ReportPr ocessing.P rocessingA bortedExce ption: An error has occurred during report processing. ---> Microsoft.ReportingService s.ReportPr ocessing.R eportProce ssingExcep tion: Cannot impersonate user for data source 'AutoGen__5C6358F2_4BB6_4a 1b_A16E_8D 96795D8602 _'. ---> Microsoft.ReportingService s.Diagnost ics.Utilit ies.LogonF ailedExcep tion: 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.ConfigurationMan agement.Ma nagementPr ovider.Sms Exception
An error has occurred during report processing.
Stack Trace:
at Microsoft.ConfigurationMan agement.Ad minConsole .SrsReport ing.Parame terPresent er.GetPara meters()
at Microsoft.ConfigurationMan agement.Ad minConsole .SrsReport ing.Parame terPresent er.LoadPar ameters(IR eport report, Collection`1 navigationParameters, IResultObject resultObject)
at Microsoft.ConfigurationMan agement.Ad minConsole .SrsReport ing.Report ViewerPres enter.Work er_DoWork( Object sender, DoWorkEventArgs e)
at System.ComponentModel.Back groundWork er.OnDoWor k(DoWorkEv entArgs e)
at System.ComponentModel.Back groundWork er.WorkerT hreadStart (Object argument)
-------------------------- -----
System.Web.Services.Protoc ols.SoapEx ception
An error has occurred during report processing. ---> Microsoft.ReportingService s.ReportPr ocessing.P rocessingA bortedExce ption: An error has occurred during report processing. ---> Microsoft.ReportingService s.ReportPr ocessing.R eportProce ssingExcep tion: Cannot impersonate user for data source 'AutoGen__5C6358F2_4BB6_4a 1b_A16E_8D 96795D8602 _'. ---> Microsoft.ReportingService s.Diagnost ics.Utilit ies.LogonF ailedExcep tion: 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.ConfigurationMan agement.Ad minConsole .SrsReport ing.Parame terPresent er.GetPara meters()
at Microsoft.ConfigurationMan agement.Ad minConsole .SrsReport ing.Parame terPresent er.LoadPar ameters(IR eport report, Collection`1 navigationParameters, IResultObject resultObject)
at Microsoft.ConfigurationMan agement.Ad minConsole .SrsReport ing.Report ViewerPres enter.Work er_DoWork( Object sender, DoWorkEventArgs e)
at System.ComponentModel.Back groundWork er.OnDoWor k(DoWorkEv entArgs e)
at System.ComponentModel.Back groundWork er.WorkerT hreadStart (Object argument)
-------------------------- -----
Please Help
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.ReportingService
--------------------------
Microsoft.ConfigurationMan
An error has occurred during report processing.
Stack Trace:
at Microsoft.ConfigurationMan
at Microsoft.ConfigurationMan
at Microsoft.ConfigurationMan
at System.ComponentModel.Back
at System.ComponentModel.Back
--------------------------
System.Web.Services.Protoc
An error has occurred during report processing. ---> Microsoft.ReportingService
Stack Trace:
at Microsoft.ConfigurationMan
at Microsoft.ConfigurationMan
at Microsoft.ConfigurationMan
at System.ComponentModel.Back
at System.ComponentModel.Back
--------------------------
Please Help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am logged in using an administrators account, I am in the SCCM-Admin group on AD, where are the group configurations on AD?
ASKER
sorry guys, I am completely new to SCCM.
ASKER
I found it ( the security settings ) and its completely the same as my production, I still cant fathom why its not working?
ASKER
Check out the reporting Service configuration...maybe some screenhots
ASKER
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?
ASKER
sorted ! the service account was not part of the sql admin group!
ASKER
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
Accepted answer: 0 points for kay07949's comment #a39894906
for the following reason:
The service account was not part of the SQL admin group
Cannot impersonate user for data source 'AutoGen__5C6358F2_4BB6_4a