none
Access Denied on Report Manager URL

    Question

  • I'm having issues trying to access the Report Manager URL, after i've installed the SQL 2008 reporting services.

    When i click on the link, this is the page returned.

    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 'C:\Program Files\Microsoft SQL Server\MSRS10.SF\Reporting Services\ReportManager\home.aspx'.


    Version Information: Microsoft .NET Framework Version:; ASP.NET Version:2.0.50727.3053  

    I've gotten reporting services working on other boxes, but for some reason i can't figure out why i get this error.

    The service account is configured to use the LocalSystem.

    For the database account, it's using localsystem, and doesn't seem to have any issues connecting.

    I've added my local account into the ReportServer user group, and tried a number of things, but i keep getting this access denied error.

    Anyone have suggestions on what might be wrong??

    Thanks in advance.

     

     

     

    Tuesday, January 27, 2009 7:32 PM

Answers

  • I found a solution. In the rsreportserver.config file, i remove all the authentication types except the Basic authentication type...and that worked.

    The box is a windows XP stand alone box.

    Anyway, this is just for development purposes, so using Basic Authentcation is fine.

    Friday, January 30, 2009 3:11 PM
  • Hi,

    If you are deploying Reporting Services on an Internet-facing Web server, you should replace Windows authentication with a custom authentication extension that gives you more control over how external users are granted access to the report server.  Below documents are helpful for you.

    Configuring Authentication for Reporting Services

    http://msdn.microsoft.com/en-us/library/bb283249(SQL.90).aspx

    Configuring a Report Server for Internet Access

    http://msdn.microsoft.com/en-us/library/ms159272(SQL.90).aspx

    Usually, modify rsreportserver.config file is also a method to change configuration. But if you encounter any issue about SSRS, it’s recommended to check report server log to find out detailed information.

    For SQL 2005 “C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles\”

    For SQL 2008 “C:\Program Files\Microsoft SQL Server\MSRS10.<instance_name>\Reporting Services\LogFiles\”

    Hope this helps.


    Garsy Liang - MSFT
    Tuesday, February 03, 2009 6:44 AM

All replies

  •  Check is this KB article is helpful: http://support.microsoft.com/kb/294382
    This posting is provided "AS IS" with no warranties, and confers no rights
    Tuesday, January 27, 2009 7:42 PM
  • Thanks for the link, but it's not relevant to the error i'm getting.

    Sql reporting services 2008 actually runs on it's own web-server...it doesn't use IIS. So, this error message is coming from that server, which i don't believe i have access to.

    Any other ideas?

     

    Tuesday, January 27, 2009 8:36 PM
  •  Check the security settings  on ReportManager folder. Users should have "Read", "Read&Execute" permission. Also are you running on a Vista/Win2k8 box?
    Tuesday, January 27, 2009 10:11 PM
    Answerer
  • I found a solution. In the rsreportserver.config file, i remove all the authentication types except the Basic authentication type...and that worked.

    The box is a windows XP stand alone box.

    Anyway, this is just for development purposes, so using Basic Authentcation is fine.

    Friday, January 30, 2009 3:11 PM
  • Hi,

    If you are deploying Reporting Services on an Internet-facing Web server, you should replace Windows authentication with a custom authentication extension that gives you more control over how external users are granted access to the report server.  Below documents are helpful for you.

    Configuring Authentication for Reporting Services

    http://msdn.microsoft.com/en-us/library/bb283249(SQL.90).aspx

    Configuring a Report Server for Internet Access

    http://msdn.microsoft.com/en-us/library/ms159272(SQL.90).aspx

    Usually, modify rsreportserver.config file is also a method to change configuration. But if you encounter any issue about SSRS, it’s recommended to check report server log to find out detailed information.

    For SQL 2005 “C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles\”

    For SQL 2008 “C:\Program Files\Microsoft SQL Server\MSRS10.<instance_name>\Reporting Services\LogFiles\”

    Hope this helps.


    Garsy Liang - MSFT
    Tuesday, February 03, 2009 6:44 AM
  • I have the same problem as yours but I dont have Basic Authentcation in the rsreportserver.config file. Can you help?
    Saturday, April 11, 2009 8:52 PM
  • Look here

    http://msdn.microsoft.com/en-us/library/ms157273.aspx#bkmk_Authentication


    You need this for Basic

    RSWindowsBasic

    This worked for me as well.

    Thanks!

    Friday, September 14, 2012 9:07 AM