Good afternoon,
I've just started using SQL Server 2005 Reporting Services and after managing to deploy it, on the dev server, I've found myself unable to manage the users that can access it. After searching on the web I've noticed that only windows users can access Reporting Services (unless you develop your custom authentication system using the extentions). That's ok for now, the problem is that I can't seem to find where to assign permissions to the windows users.
The bottom line is that I would like configure reporting services in a way that some users can add reports while others can only view them, as well as making their own using ad-hoc reports. Could someone help me out with this? :)
I started to answer a similar question here:http://forums.asp.net/thread/1573629.aspx
Within the security area you will see the different type of access that are available:
Browser Role : Run reports and navigate through the folder structure.
Content Manager Role : Define a folder structure for storing reports and other items, set security at the item level, and view and manage the items stored by the server.
Report Builder Role: Build and edit reports in Report Builder.
Publisher Role: Publish content to a report server.
My Reports Role : Build reports for personal use or store reports in a user-owned folder.
System Administrator Role: Enable features and set defaults, set site-wide security, create role definitions, and manage jobs.
System User Role : View basic information about the report server such as the schedule information in a shared schedule.
'Roles Copied straight outta the help'
I've found it's easier to set up Global groups within the Active Dir and add them to RS2005, it's a lot easier to manage the users.
No comments:
Post a Comment