Permission problem with reporting? (Part 11)

[pxedave]

I'm on Part 11 (Reporting) and I have a strange one. I'm able to access role administration via IE as described above, but when I add the Report User or Report Administrator role to any accounts (either SMSAdmin or SMSReportsUser), 30 seconds later I refresh the screen and those roles have been removed! Some roles do seem to stick, but not the two Report ones. And when I try and access reports (via IE or the SCCM console) I get an error in a messagebox like the one I've pasted below. Any ideas what I might be missing here? FYI my SMSReportsUser is just a Domain User as I didn't see any step telling me to add it to anything else...

 

Microsoft.Reporting.WinForms.ReportServerException

An error has occurred during report processing. (rsProcessingAborted)

 

Stack Trace:

at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)

at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)

at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)

at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()

at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()

at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)

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

Microsoft.Reporting.WinForms.ReportServerException

Cannot impersonate user for data source 'DataSource1'. (rsErrorImpersonatingUser)

 

Stack Trace:

at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)

at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)

at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)

at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()

at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()

at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)

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

Microsoft.Reporting.WinForms.ReportServerException

Log on failed. (rsLogonFailed)

 

Stack Trace:

at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)

at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)

at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)

at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()

at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()

at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)

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

Microsoft.Reporting.WinForms.ReportServerException

Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)

 

Stack Trace:

at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)

at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)

at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)

at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()

at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()

at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)

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

[pxedave]

OK I think I have this one. See the following article. My local policy being enforced on my server OU only had a only a couple of accounts in the ALLOW LOG ON LOCALLY setting. I needed to add the SMSReportsUser account which I created earlier. It then burst into life.

 

http://technet.microsoft.com/en-us/library/cc161372.aspx