I have recently set ssrs on my employers remotely accessed server. The problem I am having is that no matter what permissions i change on the report server itself, whether that is the site settings giving either user or system administrator privileges or the folder settings. Users of the domain cannot access the report server. The only users that can access the report server are the users that are set to system administrators in active directory on the domain itself independent of the report server.
Even if i do not give a user permissions on the report server they can still access the report server if they are an admin. But i have 14 users that need access to the reports, how can i give them permissions without giving them administrator access to the domain, database, and server.
Users experience the following error message "The permissions granted to user 'domain\user' are insufficient for performation this operation. (rsAccessDenied) "
My official final answer that works 100% for all users is as follows. You must create a user in the database using SSMS. The users name should be domainname\"domain users" the domain users is a group that contains all users. as long as that group is added to the logins on ssms in the security folder of the database. then all users can have access to the report server. NOTE: make sure that you give permissions on the report server manager to "domain"\domain users