Hello Everyone!
We migrated the SCCM database from the old Windows Server 2016 (sql enterprise 2016) to the new 2022(sql standard 2022 ).
Everything was done according to the documentation, the migration was successful. Everything works except for the integration with ReportServer.
The report server role was reinstalled. The service account is the sysadmin and dbowner of the SCCM and report servers databases.
But the srsrp log constantly contains errors:
Error retrieving users - [The EXECUTE permission was denied on the object 'fnIsSiteInMaintMode', database 'CM', schema 'dbo'.~~The SELECT permission was denied on the object 'RBAC_Admins', database 'CM', schema 'dbo'.].
and the same for the vRBAC_DetailedPermissions object.
Even if you issue a grant like this: USE YourDBName;
GRANT EXECUTE ON dbo.fnIsSiteInMaintMode TO [YourUserOrGroup];
GRANT SELECT ON dbo.RBAC_Admins TO [YourUserOrGroup];
the error in the log spams every 10 minutes. Error on every report in the ConfigMgr directory
Because of this, there is no integration with the report server and, accordingly, users do not have access to reports from the SCCM console(only Administrators have access). SCCM resets the permissions of the root folder to BUILTIN\Administrators every 10 minutes.
The errors are quite strange, since the reportserver account has access.
Maybe someone has encountered something similar? Please help.
We migrated the SCCM database from the old Windows Server 2016 (sql enterprise 2016) to the new 2022(sql standard 2022 ).
Everything was done according to the documentation, the migration was successful. Everything works except for the integration with ReportServer.
The report server role was reinstalled. The service account is the sysadmin and dbowner of the SCCM and report servers databases.
But the srsrp log constantly contains errors:
Error retrieving users - [The EXECUTE permission was denied on the object 'fnIsSiteInMaintMode', database 'CM', schema 'dbo'.~~The SELECT permission was denied on the object 'RBAC_Admins', database 'CM', schema 'dbo'.].
and the same for the vRBAC_DetailedPermissions object.
Even if you issue a grant like this: USE YourDBName;
GRANT EXECUTE ON dbo.fnIsSiteInMaintMode TO [YourUserOrGroup];
GRANT SELECT ON dbo.RBAC_Admins TO [YourUserOrGroup];
the error in the log spams every 10 minutes. Error on every report in the ConfigMgr directory
Because of this, there is no integration with the report server and, accordingly, users do not have access to reports from the SCCM console(only Administrators have access). SCCM resets the permissions of the root folder to BUILTIN\Administrators every 10 minutes.
The errors are quite strange, since the reportserver account has access.
Maybe someone has encountered something similar? Please help.
