Share via

Access to a resource

Frost, Roderic 0 Reputation points
2026-04-22T15:39:18.4466667+00:00

Can anyone help me please. I'm trying to get an employee access to the street sheet page but can't find the proper access ticket to enter in Cherwell. Here is the link page https://ssrs2022-prod.corp.chartercom.com/Reports/report/SOR/TechOps/Midwest_Region/Street_Sheet_Ultimate_Midwest

User's image

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

0 comments No comments

Answer recommended by moderator

Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
2026-04-22T21:05:38.7366667+00:00

This is a public forum, but it seems that you have a problem you run in your organisation. I tried the link, but my browser was not able to resolve the address.

No one here can help you. You will need to talk with someone in your organisation. Your IT people, your manager, or someone who is responsible for this production in your organisation.

Was this answer helpful?

1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. AI answer

    2026-04-22T15:39:44.3+00:00

    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:

    1. Open the SSRS web portal (Reports site) on the SSRS server.
    2. Go to the Home folder (or the folder path SOR → TechOps → Midwest_Region).
    3. Select the Street_Sheet_Ultimate_Midwest report (or the parent folder if access should apply to all reports in that folder).
    4. Open ManageSecurity (or equivalent security option in the portal).
    5. Choose Add group or user.
    6. Enter the employee’s Windows account or an appropriate AD group.
    7. 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.
    8. Save the role assignment.

    If the employee also needs access to the SSRS site itself (for example, to browse folders), the admin should:

    1. In the portal, select the gear icon → Site settings.
    2. Go to SecurityAdd group or user.
    3. 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:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

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.