Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested answer

SSRS - Global Discovery Service - Connection String

(0) ShareShare
ReportReport
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!

  • 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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans