SQLTeam.com | Weblogs | Forums

Ssrs 2008 sql authenication


#1

I want to ask the following about sql server authentication on an SSRS 2008 report:

  1. When the ssrs 2008 report is running, can sql server authentication be used for 'groups' of users? If so, would you show me how to setup these groups of users?

  2. Also can there be individual user access within a group of users? For example if the 'group' is setup for 'Company X', can individual access be setup for each individual user within the group? Basically I would want each user to only have access to certain 'portions' of the reports? Would you show me the code and/or point me to links (urls) that will tell me how to accomplish this goal?


#2

ReportManager has full support for access controls, both at the AD Group level and the individual userid level.


#3

Would you tell me and/or point me to links (urls) on how to use report manager to access authentication at the individual userid level?


#4

just google "sql server report manager" and you'll get tons of links. This is near the top:

How to: Start Report Manager - TechNet - Microsoft
https://technet.microsoft.com/en-us/library/ms156496(v=sql.100).aspx