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
Hope it helps.
Sharing my knowledge and experience about the Microsoft Power Platform.
a guide to powering up community
Technical Leadership Centred Around the Microsoft Data Platform
Deriving Solutions and features on Power Platform/Dynamics 365
Thoughts & musings from a Dynamics 365 Ninja!
Learn about Microsoft Dynamics CRM Power Platform customization and implementation and other cool stuffs
I know pre-stroke. I will improve who I was.
Balu Gajjala
Power Melange By Shalinee
Power Automate - Power Apps - SharePoint Online - Azure - Nintex - K2 - Artificial Intelligence
An Inquiry in Being
The Influencers & Influences of Indian Music
Hand's-free money management
A closer look at Microsoft Dynamics 365.
Experienced consultant primarily focused on Microsoft Dynamics 365 and the Power Platform
Specific topics by Django Lohn on the whole Microsoft365 Stack
One Stop Destination for Microsoft Technology Solutions
Naturally Curious
Prasanna Vadlamudi
Power Platform and Dynamics 365
A Microsoft Business Applications MVP
Bass defines your home theater
SQL Server tips and experiences dedicated to my twin daughters.
Discovering Azure DevOps and D365 Business Applications
Lets do IT Spells
český jiřetín
Russ Parry REALTOR®
Power Platform & Dynamics CRM
Mail to crmtipsbyprm@gmail.com for queries and suggestions
Giving back to the community what I have learned
Learn and Share
Dynamics CRM Technical & Functional Info
Sometimes you need to look at things from different perspective.
Dynamics 365 Customer Engagement, CRM, Microsoft CRM, Dynamics CRM
Step into the world of a Dynamics 365 Consultant
Diana & Dynamics 365 & Power Platform
No Code Customization Concepts
Nishant Rana's Weblog 
Thanks!
For me it works!
Sharing knowledge saves our lives =)
LikeLike
thanks.this is very helpful article. solved my issue.
LikeLike
Good to know that it helped you Rizwan.
LikeLike
What if SQL Server and SSRS are on 2 different servers?
LikeLike
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.
LikeLike
Fixed it for me. Thanks a bunch
LikeLike
I’m having a similar issue and tried your solution, but it did not resolve my issue 😦
LikeLike
Doesn’t do anything, this is the default set up…
LikeLike
Thanks! Worked for me.
LikeLike
Thanks!!! Finally I got my reports running
LikeLike
It save my project, thanks for your sharing.
LikeLike
Glad to know that it helped.
LikeLike
Thank you very much!
LikeLike
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.
LikeLike
I had the same error and it was because the report extensions was on UR2, but the server on UR13…
LikeLike