Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed

SSRS…Wonderful technology!!!
When you receive errors while development using SSRS 2008, you start understanding how wonderful it is…
Moral of the story, I received following error when I was 07ying to view some of the reports after configuring my Report Server - Verify that sufficient permissions have been granted and Windows User Account Con07ol (UAC) res07ictions have been addressed.
There are few concrete steps mentioned below which will resolve this error –
1.     Start Internet explorer and on “Tools” menu click “Internet Options”.
2.     Click “Security” – “Trusted Sites” – “Sites”.

3.     Under “Add this Web site to the zone”, type http://your-server-name. Make sure the uncheck the checkbox labeled as “Require server certification (https:) for all sites in this zone”. Then click ADD.
4.     Similarly add http://localhost/ and the close all popped up windows including Internet Explorer.

5.     Start Internet Explorer again in mode “Run as Adminis07ator” by right clicking on Internet Explorer icon.

6.     Open the URL of report manager - you can find URL in reporting services configuration wizard as shown. I have configured my server on port 45555. Bede fault URL will be –
http://your-sever -name/Reports
If you are using SQLExpress then URL will be - http://your-server-name/reports$sqlexpress
If you are using Named instance of SQL Server then URL will be – http://your-server-name/reports$InstanceName

7.     In the right corner click on “Site Settings”. Then click on “Security” tab. The select “New Role Assignment”.

8.     Type “your-Domain\User-Name” and select “System Adminis07ator” checkbox. Then click OK.

9.     Now click “Home” to go back to main page.
10.   Then click on “Folder Setting”.

11.   Again click on “New Role Assignment” as shown below.

12.   Enter Your-Domain\UserName and select “Content Manager” checkbox. Click OK to add user as shown below.

13.   Close Report Manager. Now open Internet Explorer in normal mode without “Run as Adminis07ator” and you should not receive error mentioned in title.
Hope this helps.
Cheers…
Happy Reporting!!!

Comments

Popular posts from this blog

The request has both SAS authentication scheme and 'Bearer' authorization scheme. Only one scheme should be used

Getting Started with Logic Apps - AS2

How to Debug and Trace request in Azure APIM - Portal, Postman, RequestBin