Can anyone please help me in understanding the security/user requirements to access SSRS reports from SQL and also .Net reporting tool. As of now I am passing a user's credentials from .net system but this is working only for Admin users. I couldn't figure out how to fix this.
Thank you.