By default I only see System admin and System user in the role assignment window. When i set up an new application role in the db for a user to only view reports if i check db_datareader, and db_datawriter, and guest , does that do the trick?

Hello, The common user only needs to be member of the role "Browser" to open report; see Granting Permissions on a Native Mode Report Server; there are no further permissions requiered, especially not on database level.Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing

Olaf thanks for the reply , The only pre defined Roles that i see are System Administrator View and modify system role assignments, system role definitions, system properties, and shared schedules. System User View system properties, shared schedules, and allow use of Report Builder or other clients that execute report definitions.

Those are server wide roles. Click on the folder to which you want users have access and then click on the properties tab. Then click on security > new role assignment. Add the user/group and select the appropriate role.

Works Like a charm THANKS!!!

Glad that it worked!