Saturday, September 01, 2012 2:16 AM
I am trying to configure the reporting in my machine (windows 7). I have successfully installed SQL server 2008 with Business Intelligence features. Now i am unable to configure the reports and reportserver to view the created reports. It would be really helpful if someone can guide me through this.I have configured it through reports configuration manager after seeing and reading some forums and blog but still throwing the same error, which is as follows,,
url : http://localhost/reports
Access is denied.Description: An error occurred while accessing the resources required to serve this request. You might not have permission to view the requested resources.
Error message 401.3: You do not have permission to view this directory or page using the credentials you supplied (access denied due to Access Control Lists). Ask the Web server's administrator to give you access to 'E:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager\home.aspx'.
Saturday, September 01, 2012 2:42 AMCould you try running Internet Explorer with Run as Adminstrator option and then trying the report server?
Saturday, September 01, 2012 2:50 AM
Now i tried to open the report manager url in IE with run as administrator, it gives me a different error which is shown below,
Server Error in '/Reports' Application.
Parser ErrorDescription: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.
Parser Error Message: The type initializer for 'System.Web.UI.BaseParser' threw an exception.
Line 1: <%@ Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.HomePage" %> Line 2: <%@ Register TagPrefix="MSRS" Namespace="Microsoft.ReportingServices.UI" Assembly="ReportingServicesWebUserInterface" %>
Source File: /Reports/home.aspx Line: 1
Version Information: Microsoft .NET Framework Version:; ASP.NET Version:2.0.50727.4927
Saturday, September 01, 2012 4:50 AM
Dinesh, looks like SQL Server Reporting needs to be re-installed.
Firstly, try logging on to Reporting Services Configuration and determine if you are able to see if all are configured properly i.e. Service Account (see if this account is having administrator privileges), Web Service URL, Database (Check Test Connection), Report Manager URL.
If its failing in any of these, try Add/Remove Programs, Microsoft SQL Server 2008 R2-> Change/Repair and repair the installation.
If this too fails, then try re-installing the component.