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.