Wednesday, January 25, 2023

SQL Server Reporting Services Error - Report Manager Permissions

In order to access Report Manager (SSRS 2014) on my local pc for Development purposes, I would open IE 11 as Administrator and go to the URL http://my-pc-name/Reports/Pages/Folder.aspx - I could access the entire site - including the Home/Folder.apx.
Recently, IE 11 no longer allowed to be opened, it forces me to switch over to Edge, which does not work because I get the permissions error (see below). Ditto for Chrome, Firefox.
User 'BLAHBLAH\myusername' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
I can publish reports from Visual Studio but my problem was changing the datasource - it is located in different folder or something strange. So I really just need access to the Admin site to update that.
I think I should have researched before I lost access to figure out what the permission issue was but it was too late...I have been doing it this way of working for like 10 years!
UNTIL I thought to access the url using the DISSENTER browser made by GAB - and it WORKED. (I ran it as Administration just in case) I then was able to access the folder page and grant my local user every darn permission needed to access everything.
Hope that helps!