Customer experience | Sales, Customer Insights,...

SSRS - Global Discovery Service - Connection String

(0) Share

Report

Posted on by jklemetsrud

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!

All responses (2)

Answers (0)

Suggested answer

jklemetsrud 240 on at

Like (0)

Report

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!
Esteban Coto Alfaro on at

Like (0)

Report

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.