SQL server report error - "rsInternalError"

Question

When I try to access the Report Server (or open up a report), I get the following error,

An internal error occurred on the report server. 
See the error log for more details. (rsInternalError)
For more information about this error navigate to the report server 
on the local server machine, or enable remote errors

When I checked the server, both "SQL Server (MSSQLSERVER)" and "SQL Server Reporting Services (MSSQLSERVER)" services are running.

Could not figure out any issue and I have restarted both the services. Then reports started working. Actually restarting the SSRS service is enough it seems. After few hours, this issue happened again, I have restarted both the services, it started working again.

We are using SQL Server 2008 R2

Reportserver logfile, stacktrace

   --- End of inner exception stack trace ---
library!ReportServer_0-3!1e54!11/12/2013-17:38:06:: e ERROR: Throwing Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: , Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.IO.FileLoadException: Could not load file or assembly 'Microsoft.ReportingServices.UpgradeScripts, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.
File name: 'Microsoft.ReportingServices.UpgradeScripts, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
   at Microsoft.ReportingServices.Library.ConnectionManager.get_ReportingServicesVersionNumber()
   at Microsoft.ReportingServices.Library.ConnectionManager.IsUpToDateDatabaseVersion(String storedDBVersion)
   at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectDBVersion()
   at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
   at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()

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 ---;

What can be the issue?

Fandango68 Fandango68 · Accepted Answer · 2014-02-24T04:57:40

It could also be that the Reporting Services database is down.

Have you accidentally detatched what you thought was an old or temporary database, but it turns out to be part of the SQL Server environment?

Check that ReportSever and ReportSeverTempDB are both attached in SQL Server and running.

SQL server report error - "rsInternalError"

4 Answers