Permissions granted to user are insufficient Error

Permissions granted to user are insufficient Error

Post by U2hlaWxhIE » Thu, 16 Oct 2008 07:05:02


'm new to Reporting Services and I'm trying to test some examples. The one
I'm working on is listed in the following:

http://support.microsoft.com/kb/875447 - How to create a sample application
that uses the Reporting Services SOAP APIs to render a report to a selected
file format on a Web page

I'm using VS 2005 and SQL-Server 2005. How do I correct the following error?

System.Web.Services.Protocols.SoapException was unhandled by user code
Message="System.Web.Services.Protocols.SoapException: The permissions
granted to user 'XXXXXXXXXXX\\ASPNET' are insufficient for performing this
operation. --->
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The
permissions granted to user 'XXXXXXXXXXX\\ASPNET' are insufficient for
performing this operation.\n 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)\n at
Microsoft.ReportingServices.Library.GetDataForExecutionAction._GetDataForExecution(CatalogItemContext
reportContext, ClientRequest session, String historyID,
DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting,
DateTime& snapshotExecutionDate, ReportSnapshot& snapshotData, Int32&
pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings)\n at
Microsoft.ReportingServices.Library.GetDataForExecutionAction.ExecuteStep(CatalogItemContext
reportContext, ClientRequest session, DataSourcePromptCollection& prompts,
ExecutionSettingEnum& execSetting, DateTime& executionDateTime,
ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap,
PageSettings& reportPageSettings)\n at
Microsoft.ReportingServices.Library.CreateNewSessionAction.Save()\n at
Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String
Report, String HistoryID, ExecutionInfo& executionInfo)\n --- End of inner
exception stack trace ---\n at
Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String
Report, String HistoryID, ExecutionInfo& executionInfo)\n at
Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)"
Source="System.Web.Services"
Actor="http://localhost/ReportServer/ReportExecution2005.asmx"
Lang=""
Node="http://localhost/ReportServer/ReportExecution2005.asmx"
Role=""
StackTrace:
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at SSRSWebService.ReportExecutionService.LoadReport(String Report,
String HistoryID) in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary
ASP.NET
Files\ssrsviewer_web_pdf\97aa90ed\eb8eede\App_WebReferences.4ar5lplv.0.cs:line 221
at _Default.viewReport_Click(Object sender, EventArgs e) in
c:\Inetpub\wwwroot\SSRSViewer_Web_PDF\Default.aspx.cs:line 40
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String
eventArgument)
 
 
 

Permissions granted to user are insufficient Error

Post by U2hlaWxhIE » Sun, 19 Oct 2008 01:02:00

I found my problem! What I had to do is grant the ASPNET user permissions to
the Reporting Services Home directory thru SQL Server Management Studio. The
permissions I granted are Browser and Content Manager.

I have one more question. What are the recommanded permissions for the
ASPNET user?