Could not find stored procedure 'sp_tr_GetBytes'
Environment
Product | Progress® Telerik® Report Server (with 15 CAL users) |
Operating System | Windows |
Description
The Report Server web management application fails with the error message 'Could not find stored procedure 'sp_tr_GetBytes'
.
Solution
The error could occur when using MsSqlServerStorage as it requires a configured MSSQL database.
Please test the following:
Create a blank database on an MSSQL server instance accessible by the deployment machine;
Close all browsers;
Rename or delete the configuration file {Report Server Installation Folder}\Telerik.ReportServer.Web\ReportServerAdmin.config
When you start
http://yourreportserverhost:83
, selectMsSqlServerStorage
from the initially provided options and enter the connection string to the database configured in step 1. Verify the database is accessible by the identity of the IIS Application pool associated with the Report Server Web part.
If this does not help, try to uninstall and then reinstall Telerik Report Server in a custom folder (configured in the installer). Our recommendation is to use the MSI file from your Telerik account
-> Downloads
-> Progress® Telerik® Report Server
-> MSI and to run the installer with administrator rights. Then execute step 4. again.