Database Shrink and Database Backups
Issue: Database shrink cause database full and log backups to fail. Fix: Make sure to disable database backups when running database shrink.
Custom DDL file location folder for RDL
Make sure the DDL file is place in this folder and has the following property set… D:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin File -> Properties -> General -> Unblock checked Checked the “Unblock” in file permission, restart SSRS services, and try uploading the RDL file again. Sources: https://forums.ivanti.com/s/article/Error-when-attempting-to-preview-a-report-in-BIDS-Failed-to-grant-permission-to-execute-Exception-from-HRESULT-0x80131418?language=en_US https://learn.microsoft.com/en-us/sql/reporting-services/custom-assemblies/deploying-a-custom-assembly?view=sql-server-ver16
SSRS Error: Could not load file or assembly or one of its dependencies. Failed to grant permission to execute.
Issue: Getting the following error when try to upload a RDL file to SSRS that uses a custom DDL file… Could not load file or assembly or one of its dependencies. Failed to grant permission to execute. Fix: Make sure the DDL file is place in this folder and has the following property set… D:\Program... » read more