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.
Related Articles
Error Log Shows Execute Permission Was Denied on the Object 'Fngetsitenumber' 19Number of Views Resolve the "execute permission denied" error for 'sp_help_job' in SQL Server 86Number of Views VMWareInventory to a VCenter fails with "Permission to perform this operation was denied" 10Number of Views Agent /etc/systemd/service/*.service file permissions should not have execute permissions 4Number of Views Agent /etc/systemd/service/*.service files should not have execute permissions 4Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago