How do I grant users rights to run reports on reporting services? Those with admin access can run them, but users without admin access can't - they get an error that they don't have access to the data source. When setting up the source, we used windows authentication. I've given clearance on the website itself and in management studio I gave the user public clearance and added her to the RSExecRole. She still gets the same error messages. I can't find any specific spot to grant access to the data sources themselves.