The solution to the SCCM error "EXECUTE permission was denied on the object 'fnlsCas'" when opening some of the Reports

Updated December 6, 20211 min readMarkdown

FYI:

In case you are using SCCM with SQL Server 2019 and are seeing the following error when opening some of the Reports.

EXECUTE permission was denied on the object 'fnlsCas'

Just install following SQL Server 2019 hotfix KB4538581 and you are good to go 👍

About the author

Ondrej Sebela
I work as System Administrator for more than 15 years now and I love to make my life easier by automating work & personal stuff via PowerShell (even silly things like food recipes list generation).

Part 23 of 29

Various PowerShell functions related to Intune, SCCM, and MDT.