none
Multiple Reporting Services Instances

    Question

  • Hello,

    I'm fairly new to SSRS. I have been working with SQL for a while, however I never have had a need to get into SSRS until now. We are trying to set up a dedicated SSRS server that will be used by multiple different applications within the organization. So instead of installing SSRS all over the place we'd just have one server dedicated to it. My question is regarding security. Do I need to set up multiple instances of SSRS on the server, one for each application that will be using it? Or, can I handle all security within SSRS and roles so that I can ensure access is not given to another applications data?

    Friday, April 11, 2014 5:58 PM

Answers

  • My question is regarding security. Do I need to set up multiple instances of SSRS on the server, one for each application that will be using it? Or, can I handle all security within SSRS and roles so that I can ensure access is not given to another applications data?

    It is not necessary to set up multiple instances of SSRS. A single instance will work however you need to provide role and permissions to different users accessing the SSRS.

    Authorization is based on roles that you assign to a principle. Each role consists of a set of related tasks, which are in turn composed of related operations. For example, the Manage reports task grants access to the following report server operations: view reports, add report, update report, delete report, schedule report, and update report properties.

    Refer http://technet.microsoft.com/en-us/library/bb522824.aspx


    Regards, RSingh

    Sunday, April 13, 2014 10:35 AM