For SQL Server Reporting Services (SSRS), access is granted by assigning the employee to the appropriate SSRS roles on the report server, not by a special “ticket” type in Cherwell.
To get the employee access to the Street_Sheet_Ultimate_Midwest report, request that an SSRS administrator do the following on the SSRS 2022 web portal for that server:
- Open the SSRS web portal (Reports site) on the SSRS server.
- Go to the Home folder (or the folder path
SOR → TechOps → Midwest_Region).
- Select the Street_Sheet_Ultimate_Midwest report (or the parent folder if access should apply to all reports in that folder).
- Open Manage → Security (or equivalent security option in the portal).
- Choose Add group or user.
- Enter the employee’s Windows account or an appropriate AD group.
- Assign an item-level role such as Browser (for read-only report access). Use Publisher or Content Manager only if the employee must deploy or manage reports.
- Save the role assignment.
If the employee also needs access to the SSRS site itself (for example, to browse folders), the admin should:
- In the portal, select the gear icon → Site settings.
- Go to Security → Add group or user.
- Add the same user or group and assign System User (or System Administrator if they must administer the site).
In Cherwell, reference this as an SSRS access request (for example, “Grant SSRS report access – add user to SSRS Browser role on Street_Sheet_Ultimate_Midwest under SOR/TechOps/Midwest_Region and System User at site level if needed”) so it routes to the team that manages SSRS permissions.
If SSRS at the organization is integrated with SharePoint instead of native mode, then the access request should go to the SharePoint admins to grant appropriate SharePoint permissions on the report library instead.
References: