SSRS

Error : Webpage error details  User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C; .NET4.0E) Timestamp: Wed, 6 Jun 2012 08:34:05 UTC   Message: Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 500 Line: 5 Char: 62099 Code: 0 URI: http://mysqlserver/Reports/ScriptResource.axd?d=XwwW1tMwtFzdBQ9-6KriOz3q0Wkgg-xPb7EWT8HUhJXnf8sz46FbnRIo5guVNx1JC-QFapCZ-oQvTRpjjwXFYypY46ebyJBSDV8_0QBsVijeeYDDkZolFtJT35QxeGTEsgsKCpzrB-ZJiu83PMYBwOjrroQ1&t=ffffffffb868b5f4 

Solution:

This problem is being caused by SQL server stopping a report being run because the request length exceeds a certain amount.

Locate the web.config files for the ReportManager & ReportServer.

These should be found somewhere like this:

C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\Web.config 

C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\Web.config 

Once located you need to edit the web.config files for both and add the  following bit of code:

<appSettings> 

<add key="aspnet:IgnoreFormActionAttribute" value="true" /> 

<add key="aspnet:MaxHttpCollectionKeys" value="100000" /> 

</appSettings> 

These app settings should be added between between /system.web and runtime  nodes, so it should look something like the following:

</system.web> 

<appSettings> 

<add key="aspnet:IgnoreFormActionAttribute" value="true" /> 

<add key="aspnet:MaxHttpCollectionKeys" value="100000" /> 

</appSettings> 

<runtime>  

NOTE: The ReportManager may already have an app settings  node so you will only need to paste the two add key lines.

------------------------------------------------------------------------------------------------------------------

Issue  :The report server has encountered a configuration error. (rsServerConfigurationError)

Installing Sql Server 2008 with Reporting Services on Windows XP I needed to do some initial configuration to make it work locally:

1. Open Configuration Manager

   1. Go to: Microsoft Sql Server 2008 > Configuration Tools > Reporting Services Configuration Manager

2. Configure Web Service Url

• 1. I used the default values suggested by configuration manager. To do that simply choose 'Apply'. Result:

Configure Report Manager Url

Again, I used the default values:

4 After onwards  doing that I tried to to access: http://localhost/Reports

In my case I got displayed the following error:

The report server has encountered a configuration error. (rsServerConfigurationError). 

To get rid of this I needed to perform to 2 extra steps:

1. Define database to use

   1. I created a new database for Reporting Services using the same configuration manager:

 2 Set folder security

Now check which account is used by reporting services:  grant access for that user to the Reporting Services installation folder. In my case it is:

C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services

 grant access for that user to the Reporting Services installation folder. In my case it is:

C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting ServicesAfter doing that I can access my Report Manager with no problems report will generate.

------------------------------------------------------------------------------------------------------------------