Permissions granted to user are insufficient Error

[Sheila Bailey]

I'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)
at
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

[Sheila Bailey]

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?

[Dominique DUCHEMIN]

Hello,

How did you do this?
I am spending a lot of time with the SSRS and FCS reporting as I could not make all batches going through...
I hope this one will resolve my issue...

Thanks,
Dom

Post by Sheila Bailey
I'm new to Reporting Services and I'm trying to test some examples. The one
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=""
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)
at
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Post by Sheila Bailey
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?
Submitted via EggHeadCafe
SQL Server CLR Stored Procedures for External Access
http://www.eggheadcafe.com/tutorials/aspnet/08c40d08-af4a-41f6-9352-91ac82b90078/sql-server-clr-stored-procedures-for-external-access.aspx