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.