I would like to kwon how I can lock down reporting services. We have a BI Team that create and manage the reports in reporting services. ie. Uploading new reports, checking the history of a schedule report & setting up new scheduled reports. And what I'm trying to do as DBA is to remove the need for the BI team to have SysAdmin right on the SQL Server but still be able to manage reporting service. But if I remove them from the SysAdmin role they can not view the history of the reports, they can't create new schedules. But the can upload new reports as longs as I give them access to write to the reporting databases.
I would like to kwon what other people have done?
Thanks
Craig