SOLVED SCCM 2012 Reporting Not Working

[namerg]

Hello,

I am testing SCCM 2012 but somehow I am not able to load reports fine.

SSRS is installed and working but not the sccm reports ?

Thoughts ?

I am uploading some screenshots when i double click on the "Administrative activity log." report.

I get this also:

An error has occurred during report processing. (rsProcessingAborted)
Cannot impersonate user for data source 'AutoGen__5C6358F2_4BB6_4a
1b_A16E_8D96795D8602_'. (rsErrorImpersonatingUser)
Log on failed. (rsLogonFailed)
The user name or password is incorrect. (Exception from HRESULT: 0x8007052E)

I do not see the Folder Settings icon on IE when I open the Reports Manager

Thanks for your help,

 

[Prajwal Desai]

I guess the issue with the user account that you are trying to access the reports. Check if its valid (not locked).

 

[namerg]

I guess the issue with the user account that you are trying to access the reports. Check if its valid (not locked).

Correct Prajwal. I do not understand why. I used a domain admin account to install sccm and sql, then i created a non domain admin account and gave full administrator right inside sccm. Eveything works fine except presenting data via ssrs. I am able to query data with both accounts inside SQL mgmt console. All is good. But not able to present data via reports.

 

[Prajwal Desai]

Does it works fine with a domain account ?.

 

[namerg]

Does it works fine with a domain account ?.

Prajwal, both accounts work fine inside SQL Mgtm Console.
Almost got it. Once i checked mark "Impersonate the authenticated user after a connection has been made to the data source" then i was able to run any reports. But, somehow the option "Impersonate the authenticated user after a connection has been made to the data source" does not remain checked mark. See screenshots/attachments.

So, how do i make the setting "Impersonate the authenticated user after a connection has been made to the data source" to be checked mark for good ?

 

[Maunil Mehta]

Hello,

SQL Server Analysis Services only supports Windows account credentials. Therefore select both options "Use as Windows credentials when connecting to the data source" and "Impersonate the authenticated user after a connection has been made to the data source" for an Analysis Services data source.

Hope this will work for sure

Problem was with domain account as per Prjawal said..
Please check either you are an SSAS admin or not . If not , get the access and be SSAS Admin..

 

[namerg]

Actually this was my solution. I am good now. Thank you. https://support.microsoft.com/en-us/kb/3074857

 

[Prajwal Desai]

@namerg - Thanks for the link. I am marking this thread as Solved.