Groups | Blog | Home
all groups > sql server reporting services > november 2006 >

sql server reporting services : Render reports exception



somuthomas NO[at]SPAM gmail.com
11/24/2006 7:11:25 AM
I am trying to render report but the following errors keeps show up:

the code where the exception shows up is:
execInfo = rs.LoadReport(reportPath, historyID);

System.Web.Services.Protocols.SoapException: The permissions granted to
user 'SYS40\IUSR_SYS40' are insufficient for performing this operation.
--->
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException:
The permissions granted to user 'SYS40\IUSR_SYS40' are insufficient for
performing this operation.
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32& executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID,
DateTime& historyOrSnapshotDate, Byte[]& secDesc)
at
Microsoft.ReportingServices.Library.GetDataForExecutionAction._GetDataForExecution(CatalogItemContext
reportContext, ClientRequest session, String historyID,
DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting,
DateTime& snapshotExecutionDate, ReportSnapshot& snapshotData,
PageSettings& reportPageSettings)
at
Microsoft.ReportingServices.Library.GetDataForExecutionAction.ExecuteStep(CatalogItemContext
reportContext, ClientRequest session, DataSourcePromptCollection&
prompts, ExecutionSettingEnum& execSetting, DateTime&
executionDateTime, ReportSnapshot& snapshotData, PageSettings&
reportPageSettings)
at Microsoft.ReportingServices.Library.CreateNewSessionAction.Save()
at
Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String
Report, String HistoryID, ExecutionInfo& executionInfo)
--- End of inner exception stack trace ---
at
Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String
Report, String HistoryID, ExecutionInfo& executionInfo)

Thanks,
Somu
tafs7
11/24/2006 5:20:25 PM
Somu,

It seems like you're allowing Anonymous authentication in IIS for the
ReportServer web app. Reporting Services security is best leveraged
using Windows authentication, so I would recommend you turn off
Anonymous auth and turn on windows auth for the ReportServer and
Reports web app in IIS.

If you really intend on using anonymous access in your Report Server,
you will need to grant the anonymous asp.net account (in your case,
SYS40\IUSR_SYS40) permissions in Report Manager, so they it can view
and browser folders, reports, and other catalog items. You can set
security for each folder and item in Report Manager by clicking the
folder or item, and selecting the Properties tab. Then on the left,
choose the Security option and add that anon account as a user w/ the
appropriate privilege(s).

Regards,
Thiago Silva, MCAD.NET

[quoted text, click to view]
AddThis Social Bookmark Button