cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SCCM log shows Execute Permission was denied on the object 'FnGetSiteNumber'

SCCM log shows Execute Permission was denied on the object 'FnGetSiteNumber'

Summary

SCCM import to FNMS may fail with the following errors if the necessary permissions are first no set

Symptoms

In the Importer.log file, the following exception is seen:

The EXECUTE permission was denied on the object 'fnGetSiteNumber', database 'CM_COR', schema 'dbo'.

Cause

SCCM reporting service used to return the data to FNMS automatically creates a login for SQL and assigns the required permissions to the account that you have specified but first the execute permission is required for this.

Workaround

To work around this issue, please add the service account to the’ smschm_users’ role on the SCCM database to grant Execute permission.

Labels (2)
Was this article helpful? Yes No
No ratings
Version history
Last update:
‎Apr 13, 2022 09:33 AM
Updated by:
Contributors