Jump to content


pxedave

Permission problem with reporting? (Part 11)

Recommended Posts

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)

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...