Hello,
in order to use the Telerik Reporting MSSQL cache I need to execute the sql described in https://docs.telerik.com/reporting/t-telerik-reporting-cache-mssqlserverstorage.
However, the database tables and stored procedures need to reside in the dbo database schema.
In my particular case I do not have access to the dbo schema, but only to custom schema.
Is it possible to specify somehow that the database objects needed for the caching reside in different schema instead of dbo?
Have you tested modifying the script to use a different schema?
The script is meant to be a short example of how one may set up the necessary tables and stored procedures, in theory, there shouldn't be issues with using another schema as long as the tables and procedures are defined correctly.
Yes I have tested to modify the script and no - It does not work when I modify the script and create all the database objects in another schema instead of dbo.
This is the error:
Error registering the viewer with the service.
An error has occurred.
Could not find stored procedure 'sp_tr_GetString'.
The above mentioned stored procedure is located in student schema. If I create all the database objects in dbo schema - everything works.