Microsoft Dynamics CRM 2011 Custom Reports not Working

Microsoft Dynamics CRM 2011 Custom Reports not Working

1. Open Reporting Services Configuration Manager at DbServer
2. At the Left Panel, Click Service Account
3. Note Account name (this account MUST have enough permission to execute costum reports)
4. Open Microsoft SQL Server Management Studio
5. Connect to Server
6. Open Security Tab at the left pane
7. Open Logins
8. Find the Account Name at 3
9. Right Click on it and then click Properties
10. Click User Mapping at the Left Pane
11. Click on Organization Database name (ex: YourOrganizationName_MSCRM)
12. Set Roles, CRMReaderRole, db_owner, public

if this steps are not work for you. check the logs in db server and eventviewer at app server.

this log file in your db server
C:\Program Files\Microsoft SQL Server\<your server version>\Reporting Services\LogFiles