<

Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error

Published on
28,941 Points
18,741 Views
2 Endorsements
Last Modified:
Awarded
Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error

With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) that will assist in prohibiting unauthorized entry into SQL Server Reporting Services. Although UAC can be disabled, working within the parameters of the new technology will strengthen the security within your company infrastructure.

There is a new process that you may run into involving SSRS for SQL Server 2008 R2 when used with Vista and/or Windows 7.  There are new UAC security steps that are used during the validation process for Report Manager.
 
 
If you receive the following error when trying to make the connection to your Report Manager:
 
  UAC Error in Report Manager
 
 
Follow the steps below:
 
Go to the report server and navigate to the following;  Start --> Administrative Tools --> Computer Management. Then Under Local Users and Groups you will see the screen below. Add the NT AUTHORITY\Authenticated Users  to the SQLServerReportServerUser group

  Add Authenticated Users to SSRS Group
 
 
Once this is done, open IE browser from the server and go to http://localhost/Reports. This will bring up Report Manager in the Home folder and display a few option.
 
From the Report Manager screen, click on Folder Settings, then go add NT AUTHORITY\Authenticated Users to this group on the root folder (This can be substituted for any other group that contains all users that will be allowed access to the Report Manger)
  Add Authenticated Users to root folder in Report Manager
 
 
Once these steps are completed, you should be able to return to the Vista and/or Win7 PC and access the Report Manager. For further permission, add specific users to each folder as you normally would. As long as Authenticated Users is in the group on the server, then each user within AD should have access once granted within Report Mangager
2
Comment
Author:aelliso3
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 5

Expert Comment

by:JermTheWorm
This is half helpful except that I can't add "NT AUTHORITY\Authenticated Users" to the list
0
 
LVL 5

Expert Comment

by:JermTheWorm
I should be able to delete my own idiotic comments... I found it. But it makes no difference my users still get asked for administrator password.
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Join & Write a Comment

In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month