SQL 2008 R2 Reporting Services if you do not have permission to view reports in IE

I have some problem with viewing reports in Internet Explorer and always get this message when I log in: Sad smile

User ‘YOUR-PC\YOU’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

After spending many hours to reading documentation and many websites how to resolve this problem I try my solution. So as we see message show we do not have permission to view reports because UAC restriction. Try to turn off UAC restriction by  typing UAC in Start->Search Programs and Files and you will see Change User Account Control settings click it or go to Control Panel –> User Accounts and Family Safety –> User Accounts and click Change User Account Control settings, you get

Turn it OFF

Capture9

Than you need to reboot your computer.

I trying login again and it is work Smile

Capture2

I can not login before because there was only BUILTIN\Administrator

Capture4

I add new role

Capture5

Capture6

and add security to in Home page open Folder Settings

Capture7

Capture8

Capture3

After adding Roles and Security  go back to UAC control and put slider on previous position(restore UAC to original state), reboot computer and try login again. Now you must login to Reporting Service

Hope this help , thanks Smile

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s