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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!