User is suddenly unable to access the SSRS Report Link or URL. User gets below error as shown in screen shot.
User ‘DOMAIN/Login_name’ does not have required Permissions. Verify that sufficient permissions have been granted and windows account control (UAC) restrictions have been addressed.
We assume that user is having necessary permissions on SSRS & still gets below error related to Permissions which misleads the troubleshooting mechanisms.
User was able to create reports & access the same reports couple of days back but not able to access somehow now.
There could be permission issues although but in our case we had just started to work on SSRS & knowledge on SSRS is limited. So please consider this as one of the approach in solving the issue.
To get this resolved you need to start you Internet Explorer as Administrator -> Run as Administrator
then open the url http://<Server name>/Reports this will take you to the “SQL Server Reporting Services” Home page
Click on the “Folder Settings” button.
Click on the “New Role Assignment” button.
Add the Group or user name: DOMAIN\USER_NAME, and permissions you have logged in as.
Click on Ok button.
This should resolve the issue.