SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Confio Ignite

Adding Users and Setting Permissions in Reporting Services

Here's a quick how-to on how to add users to Reporting Services and then how to set permissions on a folder. Did you know that by default if you add someone to the top level home folder they will have access to all the sub folders? We'll show you how to break the default inheritance and talk a little about best practices for managing users and permissions.

Duration:
5 mins 18 secs
Skill Level:
100
Rating:
4.45 out of 5
Publish Date:
February 27, 2011
Adding Users and Setting Permissions in Reporting Services You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Andy Warren
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

References

There are no downloads or recommended reading links for this video

Comments
Adi on 2/28/2011
very good

Dexter Jones on 2/28/2011
Good explanation of a subtle gotcha in SSRS. Thanks, Andy!

viquar on 2/28/2011
Nice short and to the point, would have appreciated the creation of roles in security

Don Weigend on 2/28/2011
In our company we never grant users or groups to the "User" system role. Instead we grant the "Browser" role the groups we need and that seems to work well. It seems that the "User" system role would do nothing more, is that true? Or are we missing something?

Nick Duckstein on 2/28/2011
Understanding security is always difficult. Getting a window in basics is always great. Thanks.

Zarir Patel on 2/28/2011
wasquite useful. As version changes things are done somewhat differently, so it helps to know where things are.

steve on 2/28/2011
good

Christian Bahnsen on 2/28/2011
Great job, Andy!

Charlie Bruno on 3/1/2011
Very good presentation....enjoyed it.

Keith Cooper on 3/2/2011
good content!

GW on 3/2/2011
excellent! This is just what I needed to configure my new sql 2008 r2 Reporting Services. Thanks.

Maurice Ivory on 3/3/2011
I found this to be very useful today. I'm going through this by granting access to sharepoint folders, I was telling everyone to grant access to groups not individuals.

Talha on 3/3/2011
I never thought it was that easy to provide users on the domain access to the reports. Though a bit away from SQL Server and more towards ASP but it would be nice to touch forms authentication implimentaion, as well as Report Builder

Alfred Kristinsson on 3/17/2011
Very useful

Adi on 3/25/2011
very nice

James Moore on 4/6/2011
Great job! Thank you for taking the time to put this video together. Very helpful.

Anil Babu on 6/18/2011
really good. Thanks

chris on 6/27/2011
Great Video.

Nicholas Rowan on 7/7/2011
Thanks. That was very clear and covered everything.

Mark on 11/15/2011
It may be helpful for new users for you mention that the process here is not relevant when you have Reporting Services set to Share Point Integrated mode.

shankar on 12/1/2011
Really helpful

Affzal on 1/10/2012
Good one.

Joe Hailey on 3/23/2012
Well presented and concise video

ateeq on 4/29/2012
GOOD

ateeq on 4/29/2012
GOOD

ravi on 5/6/2012
excellent



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions