SRSS 2017 web access denied

arnaud morel 96 Reputation points

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


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


    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

    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

    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

    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:
    Grant user access to a report server.

    Best Regards,

    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.