Thursday, July 24, 2008

Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\RSReportServer.config' is denied

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\RSReportServer.config' is denied.

Solution:

1. Right click RSReportServer.config file
2. GO to Properties
3. Click Security tab
4. Click Add button
5. Type "Network Service" and select "Location" as local PC.
6. Click "Check Names" button
7. Click OK; OK and you it should work now.

Server Error in '/ReportServer' Application.

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: An error occurred loading a configuration file: Access to the path 'c:\inetpub\wwwroot\web.config' is denied.

Source Error:

 
[No relevant source lines]


Source File: c:\inetpub\wwwroot\web.config Line: 0


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


Solution:


1. Check if the reportserver is running in your machine.
2. Also check if the IIS is properly configured in the machine
3. Delete Web.Config in c:\InetPub\wwwroot.

(NOTE: A common configuration mistake is to have both SSRS and SharePoint in the default web site. When SharePoint is installed it takes over the default website. SSRS website should be changed to listen on a different port, e.g. port 8080; use http://localhost:8080/reports for Report Manager and http://localhost:8080/ReportServer for Report Server if you got sharePoint installed on same server)