Lately we run into following problem: when navigating to any SSRS report via Enterprise portal or even by the SSRS report manager site, the following error is displayed where the report should appear:

An error has occurred during report processing. (rsProcessingAborted). The type initializer for 'System.Web.Configuration.RegexWorker' threw an exception.



The cause of the issue is that permissions for:

  • for SQL 2005 the account running the IIS application pool for Report Manager (should be bc proxy account)
  • for SQL 2008 the account running SSRS (should be bc proxy account)

are incorrect.
Granting admin rights to the accounts involved and then restarting IIS (or stopping starting the SQL 2008 SSRS process) can quickly prove whether you have a permissions issue. If it works with admin rights then you can remove the admin rights and make sure the accounts have permission to use DLLs in the GAC (typically C:\windows\assembly). You can verify exactly which DLL needs permission by checking the full error log at:

  • C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles for SQL 2005 Reporting Services
  • C:\Program File\Microsoft SQL Server\MSRS10\Reporting Services\LogFiles for SQL 2008 Reporting Services