21

What I want to do is log into report server manager. I have added the user to a job role in SSMS and have equally assigned the user to a specific role in Report Manager (2016). Through a secure host, I can log in with the built-in account but I am unable to log in using the created user account. The error returned is:

  Could not load folder contents
  You are not allowed to view this folder. Contact your administrator to obtain the necessary permissions.

How do I resolve this issue?

InteXX
  • 6,135
  • 6
  • 43
  • 80
UpwardD
  • 739
  • 4
  • 12
  • 36

14 Answers14

33

To eleborate on STGdb his answer. The settings on the home folder can be found at 'Manage Folder':enter image description here

Ruud van de Beeten
  • 1,185
  • 2
  • 9
  • 17
  • When I try to load this page I have the message "Could not load folder contents You are not allowed to view this folder. Contact your administrator to obtain the necessary permissions" – serhio Feb 27 '21 at 21:01
17

I had this same issue and had to adjust the permissions on SSRS at the "home" root folder on 2016

SOSidb
  • 564
  • 1
  • 13
  • 25
2

If you get the error message:

You are not allowed to view this folder. Contact your administrator to obtain the necessary permissions.

Make sure that the current account or Active Directory group is a member of the Local Administrator Group on the SSRS Server

Login to the SSRS (SQL Server Reporting Service ) Server.

Open Server Manager > Tools > Computer Management.


screenshot

Reference

aduguid
  • 3,099
  • 6
  • 18
  • 37
  • could you elaborate on "Login to the SSRS Server", what are exact steps to do it? – serhio Feb 27 '21 at 21:02
  • This worked for me also, thank you! I'd granted my domain account the "System Administrator" role from the SSRS portal > Home > Site Settings, and I could log in, but then got the message about not having permissions to view the folder contents. I also couldn't deploy reports from Visual Studio. Added my domain account to the local administrators group and bam, it all worked. – AlsoKnownAsJazz Jun 07 '22 at 12:35
2

I had the same problem. The solution is: 1- Browse the Report Manager URL 2- Top right of the page/ Manage folder/ Add group or user 3- An important point is that in Group or user, you have to insert the name which has been added before in SQL Server Report. You cannot insert your favorable name. It is the point that took me time a lot. 4- After inserting the name, choose the Browser role for that particular name. 5- Go to Home/ Your Project/ Right click/ Manage, then Security, go to Add group or user 6- Do the same as before for this step. 7- Your problem will be solved

Alireza Azad

  • This is a a direct copy/paste from the internet - at least give some credit to the original writer. Also, how is this different from Ruud's answer? Did you even go through all the answers? – deutschZuid Nov 17 '19 at 23:25
2

Just as an addendum to @gwasshoppa's post (now that IE is retired): I installed Report Server locally just to test features and ran into the same issue. The way I solved it was to create a local Windows admin account on my machine (Settings->Other Users->Add Someone else to this PC, create the account, and then Change Account Type-> Administrator). Then, in a brand new browser window (had to use a different browser even), I logged into the Report Server URL and finally saw "Manage folder". Yes, finally! I clicked Manage folder, then added my normal Windows user (which is an admin on my machine) as a Content Manager and clicked Apply. Then I reloaded the Report Server web URL and voila! I can now see everything. I hope this helps you as much as it helped me.

Alex Cook
  • 19
  • 2
  • By normal windows user you mean different from the created one? If it was already admin, as you say, then why create new admin user? – YurkoFlisk Aug 05 '22 at 17:17
1

I was getting frustrated with this, but it was simple. I did not add myself under the folder settings. Got this from Power BI Forms

Please launch browser with administrator role. And check whether current account has been granted with access permission on both System level security (under site setting) and Item level security (under Manager Folder).

https://community.powerbi.com/t5/Report-Server/Power-BI-Report-Server-You-are-not-allowed-to-view-this-folder/td-p/236338

1

If you are an administrator, login to the report server locally at http://localhost/Reports/browse/. You should see a Manage Folder button. Click that.

As an admin, I only could only see the Manage Folder button while on localhost. I had to specifically add my local user account before I could access the report server from another machine (despite the BUILTIN\Administrators group having "Content Manager" permissions).

McGlothlin
  • 2,059
  • 1
  • 15
  • 28
0

Seems like a permissions issue. Check that you have granted the user account item level permissions to view the specific folder you are trying to access. To do this, browse to the folder the reports reside in with the built-in account, click on manage, click on the security tab and grant the user the necessary permissions so that they may view the contents of the folder.

Also try to access it using Internet explorer to test Windows Authentication. The user may not currently be authenticated.

To dig deeper, you can also view the logs to see the exact permissions issue. The error log is usually located in a similar location to this:

C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles\
Louie
  • 528
  • 3
  • 8
0

The solution that worked for me was to:

  1. Verify both the ReportServer and ReportServerTempDB databases have been restored correctly.
  2. Make sure to restore the Encryption Key from the Reporting Services configuration tool.
PPS
  • 1
0

enter image description here

I was not even able to get "Manage folder" displayed in the page until i added the site in trusted sites list

Subhash Makkena
  • 1,909
  • 2
  • 13
  • 15
0

If any of the above thing won't work for you and you dont want to rebuild your SSRS services again. Just simply recreate your reportserverDB and rebuild it via reportserver configuration manager tool.

Note : please make sure you having report .rdl backup's with you handy

0

For anyone using a Microsoft Azure AD or Office 365 login to log onto their local machine and you are setting up Reporting Services on your PC, you need to do the following.

  1. Find out your PC logged in user name. To do this on your PC click the Windows Icon > Type in "Other Users".
  2. This will display a list of users on this PC. You need your user name. It will be in the form "AzureAD\MyUserName"

enter image description here

  1. Open Internet Explorer (As Administrator).

  2. Browse to your localhost report server. it will be either http://localhost/reports or https://localhost/reports depending on whether you have set up SSL.

  3. Click the "Settings" Icon top right of the page.

    enter image description here

  4. Click the "+ Add group or user" button, and enter your AzureAD\MyUserName.

  5. Tick the "Content Manager" check box and click OK. This will add your AzureAD user to the "Site Settings" as a Content Manager.

  6. Next we need to add your user as a Content Manager to "Manager Folder". To do this click the red icon top left to go to the "Home" folder. enter image description here

  7. Click the "Manage folder" button on the right top of the screen. enter image description here

  8. Repeat item 6. and 7. on this screen, and this will add your AzureAD user to the Folders as a "Content Manager".

  9. You should now be able to access the http://localhost/reports using any browser without running it as administrator.

Gwasshoppa
  • 884
  • 12
  • 18
0

I was facing the same issue with Power BI report server (developer version) which I just setup in my local laptop to test, but None of the above solution worked for me.

Problem: actually I have a domain user added as an admin and also another local admin user. All the installation etc. was done using domain admin user only. But at the end this domain user was not having permission to change site setting in portal and also it was getting logged in automatically with domain user every time I browse http://localhost/reports

solution: Opened a incognito window browse http://localhost/reports and this time it asked for username/password so I provided the local admin credentials and that worked. Now I am able to access the site settings and added my domain account in security tab.

Demetron
  • 3
  • 2
-1

All answers above are helpful. But for me helped missed here "Run browser as admin" and follow advices on this topic.

Dmitry Ivanov
  • 508
  • 7
  • 9