SRSS 2017 web access denied

arnaud morel 96 Reputation points
2021-09-22T09:43:50.66+00:00

Hi,
I have SSRS 2017 on SQL server,
for 1 month it is impossible to use an account which had admin rights and the local administrator does not have access.
It's impossible to change access.

I tested the connection with ie in administrator mode locally on the server and I get the same result.

is it possible to add the local administrator by another means?

thx for help

134281-mstsc-zalutvbcps.png134248-mstsc-jkakc3uiwd.png

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.
2,869 questions
0 comments No comments
{count} votes

Accepted answer
  1. arnaud morel 96 Reputation points
    2021-10-11T15:00:43.303+00:00

    Hi,

    ANSWER :
    Save sécurity key, save and delete report ans report_tmp database, After unistall ssrs / reboot server / install ssrs / restore report base.
    It's OK.

    Maybe it's possible to test same résolution without removing the report base

    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Olaf Helper 43,161 Reputation points
    2021-09-22T10:01:12.69+00:00

    On the server wheere SSRS is running, start the browser with right-mouse on it => "Run as Administrator" and try id again; should work.

    1 person found this answer helpful.

  2. arnaud morel 96 Reputation points
    2021-09-22T15:33:51.883+00:00

    I did an install on a new SQL instance on the same server and I have the same problem

    0 comments No comments

  3. Joyzhao-MSFT 15,571 Reputation points
    2021-09-23T01:53:39.927+00:00

    Hi @arnaud morel ,
    Could you not manage folders when you have administrator rights? This sounds very confusing.
    Please try to troubleshoot in the following three steps:

    • Login to the SSRS Report Manager.
    • Add the SSRS Report Manager URL to Local Intranet Zone in Internet Explorer.
    • Manage SQL Server Reporting Service 2017 Permissions.

    For more information,please refer to:https://spgeeks.devoworx.com/ssrs-2016-you-are-not-allowed-to-view-this-folder-contact-your-administrator-to-obtain-the-necessary-permissions/
    Grant user access to a report server.

    Best Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.