New Role Assignment in SSRS

• navpreet.khurmi

  SSC Eights!

  Points: 933

  More actions

  April 13, 2009 at 9:47 am

  #132811

  Hello,

  I have a SSRS report in an Intranet (local) environment.

  I have a link from my web server to the Report on Database server.

  My webserver has Integrated Windows Authentication checked.

  Now do I need to assign all the users access to the database and the report as that will be a pain.

  As there are more then 100 users for this report.

  As they all are local users in the domain. How Can I assign them a group permission?

  Thanks.

• vishal.gamji

  SSCertifiable

  Points: 6126

  More actions

  April 13, 2009 at 10:22 am

  #976717

  If your only concern is the monotonous creation of the 100 users, try scripting the users (automate it)

  http://www.microsoft.com/technet/scriptcenter/resources/qanda/apr06/hey0413.mspx