I was getting the above error while running one of the custom SSRS report inside CRM 2011.
To resolve this issue I had to follow these steps
- Start SQL Server Management Studio
- Expand Security, then expand Logins
- Select and right click the account under which the SQL Server Reporting Services is running.
- Select User Mapping and select YouOrg_MSCRM database and specify following role membership
- CRMReaderRole,
- db_owner
- public.
Hope it helps.
I am getting the issue randomly. If I re-run the report in few seconds it is successful. But most times it fails with this error.
Thank you very much!
It save my project, thanks for your sharing.
Glad to know that it helped.
Thanks!!! Finally I got my reports running
Thanks! Worked for me.
Doesn’t do anything, this is the default set up…
I’m having a similar issue and tried your solution, but it did not resolve my issue
Fixed it for me. Thanks a bunch
I am also having the same issue but i am unable to clear it.
after doing all these tricks also i am getting the same error.
What if SQL Server and SSRS are on 2 different servers?
thanks.this is very helpful article. solved my issue.
Good to know that it helped you Rizwan.
Thanks!
For me it works!
Sharing knowledge saves our lives =)