Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

SSRS - Unable to connect to data source

Posted on by Microsoft Employee

Today I tried to edit and existing SSRS report and received this error when trying to update the dataset.

158485.Capture.PNG

The data source has always worked in the past. There have been no changes to CRM or to the credentials used. The org I'm connecting to is called 'frpdev', so the connection string in the data source is https://disco.crm4.dynamics.com;frpdev

Has anyone seen this before?

Thanks.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SSRS - Unable to connect to data source

    In the end I uninstalled the Report authoring Extensions and uninstalled Visual Studio. After re-installing both, the problem vanished!

    Weird, annoying, but fixed. Thanks for your help

  • Suggested answer
    ashlega Profile Picture
    ashlega 34,475 on at
    RE: SSRS - Unable to connect to data source

    That last error tends to show up when you are trying to use 365 authoring extensions with VS 2012. Not sure if I have ever seen a solution for VS 2012, but it does work with VS 2015 (but, if you go that route, you`ll probably need to reinstall the extensions once you have installed VS 2015 + data tools)

    On the other hand, if you were using an earlier version of the reporting extensions before, that might be the reason why authentication stopped working.

  • RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: SSRS - Unable to connect to data source

    Check this link, it talks about the same error.Basically there is a KB to do a registry cleanup before reinstalling.

    community.dynamics.com/.../169698  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SSRS - Unable to connect to data source

    Ok I did that. Uninstalled it and re-installed the Dynamics 365 Report Authoring Extension.

    Now I'm receiving a different error message, when trying to update the data set:

    05641.Capture.PNG

    "The selected data extension MSCRMFETCH is not installed or cannot be loaded"....

    Thoughts?

    Microsoft Dynamics 365 Report Authoring Extension

  • RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: SSRS - Unable to connect to data source

    You may want to try reinstalling Report authoring extension.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SSRS - Unable to connect to data source

    I did.

    8551.Capture.PNG

    The strange thing is that the connection URL I'm using has always worked in the past:

    https://disco.crm4.dynamics.com;frpdev

    As nothing has changed in terms of CRM or the credentials (I've tried other creds and other unique org names the same problem happens), I feel it might be something to do with Visual Studio? I'm using VS 2010. 

    Also the reports still run fine in CRM directly. 

  • Suggested answer
    Thomas David Dayman Profile Picture
    Thomas David Dayman 11,323 on at
    RE: SSRS - Unable to connect to data source

    Did you go to Settings > Customisations > Developer Resources 

    Then use the Unique Name?

    4456.Screenshot_5F00_6.png

    https://orgname.crm4.dynamics.com;Unique Name

     


    You need to put in the orgname where your disco is.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans