none
Could not load file or assembly Microsoft.ReportingServices.ProcessingCore or one of its dependencies. Access is denied. RRS feed

  • Question

  •  

    My reporting server 2005 frequently throws error below.

    The PC hosting reporting server has .net framework 1.1 and 2.0 installed, and it does not have SQL server installed. The 2 databases used by reporting server are in another PC.

    Please help.

    w3wp!webserver!1!3/14/2007-07:01:35:: i INFO: Reporting Web Server started
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing ProcessRecycleOptions to '0'  as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'  as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'  as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
    w3wp!library!1!3/14/2007-07:01:35:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    w3wp!resourceutilities!1!3/14/2007-07:01:35:: i INFO: Reporting Services starting SKU: Standard
    w3wp!resourceutilities!1!3/14/2007-07:01:35:: i INFO: Evaluation copy: 0 days left
    w3wp!resourceutilities!1!3/14/2007-07:01:35:: i INFO: Running on 2 physical processors, 4 logical processors
    w3wp!runningjobs!1!3/14/2007-07:01:35:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds.  Cycle: 600 seconds
    w3wp!runningjobs!1!3/14/2007-07:01:35:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
    w3wp!runningjobs!1!3/14/2007-07:01:35:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
    w3wp!runningjobs!1!3/14/2007-07:01:35:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
    w3wp!library!1!03/14/2007-07:01:35:: i INFO: Catalog SQL Server Edition = Standard
    w3wp!library!1!3/14/2007-07:01:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
     Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.IO.FileLoadException: Could not load file or assembly 'Microsoft.ReportingServices.ProcessingCore, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.
    File name: 'Microsoft.ReportingServices.ProcessingCore, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
       at Microsoft.ReportingServices.Library.CreateNewSessionAction.Save()
       at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
       at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
       at Microsoft.Reporting.WebForms.ServerReport.SetParameters(NameValueCollection parameters)
       at Microsoft.ReportingServices.WebServer.ReportViewerHost.OnLoad(EventArgs e)

    WRN: Assembly binding logging is turned OFF.
    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
    Note: There is some performance penalty associated with assembly bind failure logging.
    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

       --- End of inner exception stack trace ---
    w3wp!library!1!3/14/2007-07:01:36:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
    w3wp!library!a!3/14/2007-07:11:35:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
    w3wp!library!9!3/14/2007-07:21:35:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
    w3wp!library!1!3/14/2007-07:31:35:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
    w3wp!library!8!3/14/2007-07:33:55:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
     Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.IO.FileLoadException: Could not load file or assembly 'Microsoft.ReportingServices.ProcessingCore, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.
    File name: 'Microsoft.ReportingServices.ProcessingCore, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
       at Microsoft.ReportingServices.Library.CreateNewSessionAction.Save()
       at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
       at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
       at Microsoft.Reporting.WebForms.ServerReport.SetParameters(NameValueCollection parameters)
       at Microsoft.ReportingServices.WebServer.ReportViewerHost.OnLoad(EventArgs e)

    WRN: Assembly binding logging is turned OFF.
    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
    Note: There is some performance penalty associated with assembly bind failure logging.
    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

       --- End of inner exception stack trace ---
    w3wp!library!8!3/14/2007-07:34:25:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
    w3wp!library!1!3/14/2007-07:41:35:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
    w3wp!library!a!3/14/2007-07:42:44:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
     Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.IO.FileLoadException: Could not load file or assembly 'Microsoft.ReportingServices.ProcessingCore, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.
    File name: 'Microsoft.ReportingServices.ProcessingCore, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
       at Microsoft.ReportingServices.Library.CreateNewSessionAction.Save()
       at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
       at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
       at Microsoft.Reporting.WebForms.ServerReport.SetParameters(NameValueCollection parameters)
       at Microsoft.ReportingServices.WebServer.ReportViewerHost.OnLoad(EventArgs e)

    WRN: Assembly binding logging is turned OFF.
    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
    Note: There is some performance penalty associated with assembly bind failure logging.
    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

       --- End of inner exception stack trace ---

    Thursday, March 15, 2007 3:17 PM

Answers

  • Hi Weo,

     

    I also have the same error as you...then I gave machine asp.net user  the full rights on folders C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\ReportSerever and Reports. And Then It works fine on my Reporting server..

     

    Regards,

     

    Balwant Patel.

    Monday, April 23, 2007 10:17 AM
  • The way to do this that is reliable is to use aspnet_regiss.exe and pass the -ga parameter.  For RS 2000 and RS 2005, you need to call it twice - first call -ga and provide the service identity of the report server service AND second, call it again and pass the application pool identity that the RS web service uses.   Hope this helps,

    -Lukasz 


    Got a bug or feature request? Tell me about it at http://connect.microsoft.com. This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, September 21, 2010 3:16 PM
    Moderator

All replies

  • Hi Weo,

     

    I also have the same error as you...then I gave machine asp.net user  the full rights on folders C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\ReportSerever and Reports. And Then It works fine on my Reporting server..

     

    Regards,

     

    Balwant Patel.

    Monday, April 23, 2007 10:17 AM
  •  

    Could I ask how you did this, Balwant? I don't see files called Report<anything> in my C:\...\Temporary ASP.NET Files directory.

     

    Thanks,

    Dina

    Thursday, October 11, 2007 11:21 PM
  • Thank you for your tip. It help me a lot.

     

    Monday, November 10, 2008 2:00 PM
  • The way to do this that is reliable is to use aspnet_regiss.exe and pass the -ga parameter.  For RS 2000 and RS 2005, you need to call it twice - first call -ga and provide the service identity of the report server service AND second, call it again and pass the application pool identity that the RS web service uses.   Hope this helps,

    -Lukasz 


    Got a bug or feature request? Tell me about it at http://connect.microsoft.com. This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, September 21, 2010 3:16 PM
    Moderator