Permissions req for non CRM users to run custom reports

[pvidya]

Hi,

I have some custom reports that run off the Filtered views in the CRM database. These reports are SSRS reports that are deployed in Report Manager and accessed outside of CRM. The users that are setup in CRM are able to view the report data fine. The users not setup in CRM cannot view the data.

So, my question is, if I want to provide access to the CRM data through these reports that use SQL queries off the filtered views - what permissions in SQL do they need and/or how should they be setup? Providing access to the CRMReaderRole in SQL Management Studio does not help.

Thank you for your time. Any suggestions/ pointers/ answers are appreciated.

Thanks.