I have been tasked with providing one role for all users to use to get into any report in SSRS..Some people access report manager and the folders within directly.. Some people use an ASP.NET wibe site that passes a user name and password to SSRS and some people use a VB.net app that passes a user name and password and send a report to a PDF output.. They was ONE single Role that I would set up in SQL Server 2008 called Report_Role.. I want to add people based on their active directory windows name( everyone is something like LEX/cemith01) to this role so no matter how they access SSRS the can get in without having to provide a user name and password... The reports data comes from the same server but different databases and some use stored procs etc.. What do you recommend and is this possible? Remember the goal is to have anyone that I assign to the 1 role be able to read or write to a SSRS report in any folder.. Just basically be able to get to report manager so they can go to the folder they want, print a report or enter data into a report.
Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers. It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.