Share via

Issues with ConfigMgr reporting

Bojan Zivkovic 621 Reputation points
2026-01-26T19:09:55.0833333+00:00

Hi, I have the following error when trying to run any CM report.

User's image

Since this is a production environment, I do not want to set this to 0.

User's image

This should be related to service account used for reporting missing something, but I need detailed instructions please since I tried many things but in vain.

Moderator: Moved from SQL Server Reporting Services

Microsoft Security | Intune | Configuration Manager | Application

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Shruti Dhruv 875 Reputation points Microsoft External Staff Moderator
    2026-01-27T09:53:57.36+00:00

    Hi Bojan Zivkovic,

    Welcome to Microsoft Q&A Forum!

    Try to verify these three things:

    1. Correct SSRS service account
    2. Correct SQL permissions for that account
    3. Correct SCCM database role membership

    If smsdbrole_reportserver is missing → reports will fail

    After permissions are fixed, restart services:
    Restart SQL Server Reporting Services , Restart SQL Server Agent.

    Then open any built‑in CM report and run it without modifying parameters.
    The report should load without UserTokenSIDs error. If it works — RBAC is now functioning correctly.

    Hope this helps!
    Regards,
    Shruti

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.