Report Server access denied

Question

question

cmapowers asked Jun 11, '10

Report Server access denied

I installed a SQL Server 2008 on my home computer and SSRS doesn't work on IE. I have changed the user id and password to match Windows authentication. Still can't get it to work. Here is the access denied message:

Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via , the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.

To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))]

[FileLoadException: Could not load file or assembly 'System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Access is denied.]
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.WriteExceptionAsHtml(TextWriter responseWriter, Exception exceptionToDisplay, Int32 code, String optionalMessage) +0
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.WriteErrorResponse(Int32 code, String shortHttpDescription, Exception exception, String optionalMessage, Boolean errorResponseAsXml) +494
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.WriteErrorResponse(Int32 code, String shortHttpDescription, Exception exception, Boolean errorResponseAsXml) +85
Microsoft.ReportingServices.WebServer.Global.WriteServerError(Exception e) +44
Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e) +232
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

ssrs security

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

cmapowers commented · Jun 12, 2010 at 03:12 PM

I tried. There isn't a security tab. Only General and Summary. The file is C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager\ Home.aspx.

0 ·

cmapowers commented · Jun 12, 2010 at 03:22 PM

I checked the box for Share this folder on the network on the ReportManager folder where the Home.aspx is. Now I am getting the website cannot display the page. I used my server name http://user7030-28f647:8080/reports. This is a student copy of SQL Server 2008.

0 ·

Answer 1 · 2010-06-12T04:13:20Z

Fatherjack answered Jun 12, '10

Did you make the changes it suggests:

"To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access."

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question