Error when diffrent user to see the reports

• SAT_SQL

  Default port

  Points: 1465

  More actions

  June 29, 2009 at 11:31 pm

  #384874

  Hi All

  I am using the sql server 2008, for reporting services, when we are deploying it is suceeded for all users , and we can t get the results for all users , we are willing to see these reports for all users , But we are login with adminstrator we can, but for the particukar user we cant

  the error is as following

  The permission granted to the user"----" are in sufficent for performing for this user.

  Sat_sql

• fayazabdu

  SSC Veteran

  Points: 261

  More actions

  June 30, 2009 at 11:02 am

  #1017787

  Hi

  I think you will have to perform two things

  1. Add all the users from Active directory to Reporting service security list with required permission.

  2. Create a role for same list of users in SSAS and add all users there also and deploy it.

  Hope this will help you