I was trying to execute Application deployments per asset and found a very odd
error:
* An error has occurred during report processing. (rsProcessingAborted)
* Query execution failed for dataset 'DataSet1'.
(rsErrorExecutingCommand)
The EXECUTE permission was denied on the object 'fnLShortNameToLCID', database
'CM_XXX', schema 'dbo'.
Went googling and found this, worked after I performed the work. Didn't know
this was an issue, at least this was resolved. Thanks to the guy who resolved
this from MS.
* If you try running the report "Software Distribution - Application
Monitoring > Application deployments per asset" it will fail. The error on the
SRS server is:
An error occurred during client rendering.
An error has occurred during report processing.
Query execution failed for dataset 'DataSet1'.
The EXECUTE permission was denied on the object 'fnLShortNameToLCID', database
'CM_CAS', schema 'dbo'
To fix it you need to go into SQL Server Management Studio and go to
Databases / CM_XXX / Security / Roles / Database roles / smsschm_users
Open the properties for smsschm_users and select securables. Unfortunately the
fnLShortNameToLCID won't show up in the list. You have to do a search for it
with the following
* Select Specific objects
* Object types select 'Scalar function'
* For Object name type in fnLShortNameToLCID
* Press OK
* You should get another dialog box come up with the function listed.
* You can now scroll down to fnLShortNameToLCID and select 'Execute'
The report should now work.
