Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Configure Reporting services 2008 in Windows 7

Answered Configure Reporting services 2008 in Windows 7

  • Saturday, September 01, 2012 2:16 AM
     
     
    Sign In to Vote
    0

    Hi ALL,

    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'.

    Thanks,

    Dineshkumar


     

All Replies

  • Saturday, September 01, 2012 2:42 AM
     
     
    Sign In to Vote
    0
    Could you try running Internet Explorer with Run as Adminstrator option and then trying the report server?
     
  • Saturday, September 01, 2012 2:50 AM
     
      Has Code
    Sign In to Vote
    0

    Yes Karthik,

    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 Error

    Description: 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.

    Source Error: 
    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
     
     Answered
    Sign In to Vote
    0

    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.