SQL Server Reporting Services
I need to get an access to our users to be able to browse to the SQL server reporting site, which is http://localhost/Reports . The only access that works is Administartor,
which I do not want to give all of the uses this access.
What permissions a user or a group needs to get an access to the report service page?
Thanks
Bahram
December 15th, 2010 7:30pm
You need to create Roles for users or group and select Browser role to access Report manager.
Please let me know if you have any questions on this..
Regards,
Senthil
Free Windows Admin Tool Kit Click here and download it now
December 16th, 2010 1:16am
Just to add..
You can use following MSDN reference to do the same
http://msdn.microsoft.com/en-us/library/ms156034.aspx
Gaurav Gupta http://sqlservermsbiblog.blogspot.com/
December 16th, 2010 1:25am
There are 2 places you need to give the user/group to be able to access reports:
1) under “Site Settings” (top right hand corner)
2) under “Folder Settings”.(folder/report level, under /Reports)
Free Windows Admin Tool Kit Click here and download it now
December 16th, 2010 12:43pm
That link helped me a lot, thanks.
But my problem is, all the users must be a member of the local Administrators group on the report server computer. This is what I found on that link, which is work fine, but I just don't like to add all the users to the SQL server as administrator.
Thank You so much.
December 16th, 2010 3:17pm