April 9, 2007 at 12:59 pm
I am new to sql server 2005, and I am trying to setup report services. I am getting the following error when I try to access http://myserver/reportserver.
Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\bin' is denied.
I have can't find any useful information on this error. I have explicitly given permissions for every account (my account, ASPNET, IUSR_myserver) to access this directory and still nothing. Has anyone else run into this? How can I solve this?
April 10, 2007 at 6:46 am
If you are trying to configure Reporting Services then go to your start menu, programs Microsoft sql server, configuration tools. It will be there. If you are trying to look at reports that have been loaded or the root directory then the path is http://servername/reports
April 10, 2007 at 8:48 am
I think RS installs using ananymous access by default. This means that the IIS user IUSR_<ServerName> is the context that the application is going to run under. This user may not have enough permissions to access the specified folder so the application cannot run.
IIS permissions can be confusing. The simplest way to verify that IIS has enough permissions to the application folders is to simply set the Everyone group in the folder permissions to full control (not the best solution, but will let you know if this is the problem). If that works, you have a folder / file permissions issue that you need to resolve by giving the appropriate user or group the proper access.
You may have had a server administrator take this IIS guest account out of the default user groups on the server to help with security.
April 10, 2007 at 9:49 am
I have tried http://myserver/reports as well, but it has the same problem. I have given the "everyone" role full control of the directory, but I am still getting this error. What else do I need to check?
April 10, 2007 at 9:58 am
Update:
I also tried editing the web.config file by adding the userName and password attributes to the identity.
authentication mode="Windows" />
identity impersonate="true" userName="localAdmin" password="adminPassword" />
This just gets me a "The page cannot be displayed error".
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply