Post reply

Security in Reporting Services

  • May 31, 2005 at 8:31 pm

    #89273

    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

     

  • June 3, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • June 3, 2005 at 9:06 am

    #562942

    Craig,

    haven't worked with it enough, but I wouldn't be surprised in SQL Server 2000 if this is not possible. Just like Bulk Insert people need sysadmin rights, they may need this in reporting services.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply