none
SSRS 2008 R2

    Question

  • Hi,

    We have SS2008 R2 and SSRS installed. For months the reporting server was working fine. The other day a consultant turned on the IIS feature in order to create a website. I believe he also installed dotnet 4.0.  Now the reporting server isn't working and serving up http 500 errors. Subsequently, we uninstalled IIS and tried loading a SSRS report but still the http 500 errors.

    How can I get the reporting server back to normal? I can see that the SSRS server is running but it can't serve up reports.

    TIA,

    Jim. 

    Wednesday, June 12, 2013 6:09 PM

All replies

  • Can you look at the SSRS logs. It is usually found under :

    %ProgramFiles%/SQLServer/%Version%/Reporting Services\LogFiles

    - Girija


    Please mark responses as answered if it helped you.. This helps others... - Girija Shankar Beuria

    Wednesday, June 12, 2013 6:38 PM
  • Here is the section of the log where the error occurs:

    appdomainmanager!DefaultDomain!1b6c!06/12/2013-14:51:53:: i INFO: Appdomain:3 ReportServer_MSSQLSERVER_0-1-130155367135333957 started.
    appdomainmanager!DefaultDomain!1b6c!06/12/2013-14:51:53:: e ERROR: AppDomain ReportServer_MSSQLSERVER_0 failed to start. Error: Could not load file or assembly 'ReportingServicesWebServer, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied. (C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\web.config line 14)
    library!DefaultDomain!1b6c!06/12/2013-14:51:53:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: Failed to create HTTP Runtime, Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_MSSQLSERVER_0.  ---> System.Web.HttpException: Could not load file or assembly 'ReportingServicesWebServer, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied. (C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\web.config line 14) ---> System.Configuration.ConfigurationErrorsException: Could not load file or assembly 'ReportingServicesWebServer, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied. (C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\web.config line 14) ---> System.IO.FileLoadException: Could not load file or assembly 'ReportingServicesWebServer, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.
    File name: 'ReportingServicesWebServer, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' ---> System.IO.FileLoadException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. Access is denied.
    File name: 'ReportingServicesWebServer'

    Wednesday, June 12, 2013 6:58 PM
  • Ok...

    What was the port on which SSRS was installed ? You can check that in Reporting Services configuration manager.

    If it is port 80 (Which is default) check if the consultant has created any other website on that same port. It might be case of port conflict.

    If that is the case here are two options :

    1. Change the SSRS report server use another port (say 5465). You need to do this for Report manger and Report Server in the Reporting Services Configuration manager.

    2. Tell your consultant to use another port for his website.

    - Girija


    Please mark responses as answered if it helped you.. This helps others... - Girija Shankar Beuria

    Wednesday, June 12, 2013 9:23 PM
  • Girija thanks, that didn't work. I just installed a second instance of SSRS and that didn't work either.
    Wednesday, June 12, 2013 10:18 PM
  • Hi Jawalker,

    "Could not load file or assembly 'ReportingServicesWebServer, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied", this error message occurs when the process or configured impersonation account does not have permissions access to the ASP.NET temporary files folder since new .net framework had been installed. To avoid this issue, please try to specify the Read/Write permission for an account to "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files" (Modify the framework version, root directory etc according to your environment).

    For more information about this issue, please see:
    http://blogs.msdn.com/b/sayanghosh/archive/2007/04/21/solution-to-could-not-load-file-or-assembly-or-one-of-its-dependencies-access-is-denied.aspx
    http://msdn.microsoft.com/en-us/library/kwzs111e(v=VS.80).aspx
    http://social.technet.microsoft.com/Forums/en/sqlreportingservices/thread/1fdce664-ed55-483d-a249-6b84f0615e45

    Regards,
    Charlie Liao

    If you have any feedback on our support, please click here.


    Charlie Liao
    TechNet Community Support

    Thursday, June 13, 2013 3:02 AM
  • Hi Charlie,

    Thanks for the suggestions but that didn't work either. I found this in the Application event log whenever I hit the ReportServer URL. It seems that SSRS is looking for some DLLs in ASP.NET 2.0 and can't find them:

    The description for Event ID 1334 from source ASP.NET 2.0.50727.0 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

    Thursday, June 13, 2013 1:06 PM