SQL Server Performance

Permission to my reports

Discussion in 'SQL Server Reporting Services' started by Reddy, Jun 28, 2005.

  1. Reddy New Member


    My issue is , how can i grant access to view reports for only some people in a group(ie; only 50 people out of 100 in a group has to be able to see reports).Can any one pls help me out from this issue, its urgent.
    Thanks in advance
  2. acc365 New Member

    Goto Report Manager Home page, click on properties, click on "New Role Assignment" and add each user by entering there log in name and select the appropriate security level, "Browser" is generally good enough.

    Hope this helps

  3. Reddy New Member

    Thanks! for ur quick reply.
    Do u mean that i have to assign role for each and every user on report manager. since i need to select some 50 users out of 100, is there any other way to set permissions for them.
  4. Reddy New Member

    How can i set parameter(code) in my dataset so tht my reports are windows authenticated.
  5. Reddy New Member

    How can I make my reports windows authenticated,where can I do that its in report manager or in my data where I am using SP. Any help?

Share This Page