Failed to load expression host assembly. Details: Could not load file or assembly or one of its dependencies. The system cannot find the file specified. (rsErrorLoadingExprHostAssembly)

Error: Got the following error after upgrading SSRS. Failed to load expression host assembly. Details: Could not load file xxxxxxx or assembly or one of its dependencies. The system cannot find the file specified. (rsErrorLoadingExprHostAssembly) Fix: For SQL Server 2014 to 2016, copy the missing dll to the new folder. From… C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting... » read more

Microsoft Report Builder

Install Report Builder https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/install-report-builder?view=sql-server-ver15

SSRS Semantic modeling language (SMDL)

Semantic Modeling Language (SMDL) SQL Server 2016+ SMDL models were deprecated as of the release of SQL Server 2014, the ability for them to function was still there. SSRS 2016 or later doesn’t support the Report Models feature. Uploading and managing report models is a discontinued feature on SQL Server 2016 (is no longer a... » read more

Retrieve SSRS RDL file from Database

You can get it from the Report Server Database. All the Reports deployed to the Server get stored in Catalog table in Binary data format and we need to convert it into XML file. And that XML file will be your actual Report. Use the following query to retrieve a list of SSRS reports with... » read more

Unable to validate the integrity of encrypted data

Error: The report server was unable to validate the integrity of encrypted data in the database. (rsCannotValidateEncryptedData) Solution: Reporting Services Configuration Manager -> Encryption Keys -> Change Need to reset data source connection in SSRS.

SSRS Permissions

Error: The permissions granted to user ‘DOMAIN\user01’ are insufficient for performing this operation. (rsAccessDenied) User permissions need to be setup both at the SQL Server and SSRS. Account can be both SQL Server account or NT account. SQL Server Account has access to database. (Database -> Security) SSRS Reports pointing to correct Data Sources file.... » read more

Calling Code from SSRS Report

Report File Code Section Note: Make sure you reference the dll in the report. DLL myapp.MyAppFacade.dll C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin

SSRS Reports vs ReportServer

Report Manager URL: http://servername/reports Report Server URL: http://servername/reportserver Report Manager is a convenient web user interface to the Report Server that enables you toview and administer your reports, data sources, and report resources. Report Server is the web service application that functions as your programmatic gateway to the SQL Reporting Services engine. When browsing to... » read more

Create Custom SSRS Security Role

Create new Role via SSMS. Add User to Role via Reporting Services web interface. Create New Role (via SSMS) Make sure you select “Reporting Services” in the Server type. Add User to Custom Role (via Reporting Server Web) Sources: