Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Suggested answer

SSRS - Global Discovery Service - Connection String

Posted on by 240

Hello everyone and thank you for your time.

The Regional Discovery Service (RDS) is going offline on June 30th, 2021, so in 6 days from now.

I see they have posted a document on how to connect to it via "code" C# etc, but there has been no mention of how we will connect to it through visual studio using SQL Server Data Tools, which does not allow you to do anything but put in a connection string, a username and a password.

When developing SSRS reports in visual studio for Dynamics 365 online, one must have SQL Server Data Tools (This is what gives visual studio the option to create "Reporting Projects". One must also have the Report Authoring Extension 9.0 - This is what gives you the option of have a data source type of FetchXML.

In the past, we would put: https://disco.crm.dynamics.com;uniquename in order to connect.

I have tried every variation of that to try and connect to the global discovery service.

https://globaldisco.crm.dynamics.com
https://globaldisco.drm.dynamcis.com;unqiuename
https://Actual_url_to_clients_crm
https://Actual_url_to_clients_crm;unqiquename

I also tired a few others.

In every instance, I get the error: FCB 'EnableRegionalDisco' is disabled

So the question is, come June 30th, are SSRS reports dead? or has someone come up with a way to still make a connection?

P.S. I have a ticket open with MS right now about this, had to record a video and they are (hopefully) looking into it.

This is a pretty big deal. I'm also willing to take any work arounds no matter how bizarre. Thanks!

Categories:
  • Suggested answer
    jklemetsrud Profile Picture
    jklemetsrud 240 on at
    RE: SSRS - Global Discovery Service - Connection String

    I meant to come back here and say that I did find a solution. If you search for just "Report Authoring Extension" you can get the wrong version. It's "Report Authoring Extension 9.0" specifically. www.microsoft.com/.../details.aspx - With this version you can use the syntax globaldisco.drm.dynamcis.com;unqiuename - and it appears to work fine now against a client I'm 100% certain had RDS disabled on. Thanks!

  • RE: SSRS - Global Discovery Service - Connection String

    Hello, I recommend you check this link: blog.csdn.net/.../117254556

    Translate the page because it is in Chinese, but explain how to solve the problem you have.

    Also check out this documentation which brings the connection string examples: docs.microsoft.com/.../use-connection-strings-xrm-tooling-connect

    Thanks!

    Community Support Team - Esteban

    If this Post helps, then please consider Accept as solution to help the other members find it more quickly.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,552 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,552 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans