Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Visual Studio 2012 rep...
Microsoft Dynamics CRM (Archived)

Visual Studio 2012 reports - can no longer connect to Dynamics 365

(1) ShareShare
ReportReport
Posted on by Tigger25

We have a number of Dynamics CRM reports that were developed in Visual Studio 2012 and are running in online Dynamics 365. I tried to create a new report today but our existing data source will no longer connect.

The connection string is set as https://disco.crm5/dynamics.com/;orgname

When I try to refresh the fields in the dataset I just get an error saying "Unable to connect to data source", with the following futher details:

The connection to server "disco.crm5.dynamics.com;orgname" could not be established. Make sure that the connection string and credentials are correct, and try again.


I know the credentials are correct as I am using the same credentials to log into CRM via Chrome, and I can also connect using XrmToolBox with these credentials.

I have also tried changing the connection string to orgname.crm5.dynamics.com which is the format the XrmToolBox connection string uses, but I get the same error.

Has something changed in the latest version of Dynamics 365?  We are on Microsoft Dynamics 365 Version 1612 (8.2.1.271) (DB 8.2.1.271) online


I need to be able to create reports in Visual Studio as the Report Wizard in Dynamics 365 online don't allow us to generate the advanced reports that we need.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Visual Studio 2012 reports - can no longer connect to Dynamics 365

    Hi

    Try removing any shared datasource and use only embedded datasource.

  • Tigger25 Profile Picture
    Tigger25 on at
    RE: Visual Studio 2012 reports - can no longer connect to Dynamics 365

    Eventually!  It gave me the following error to start with :

    "Error Uploading Report

    This report can’t upload. This issue can occur when the Report Definition Language (RDL) file is not valid. "

    But a bit of Googling solved that:

    www.itaintboring.com/.../rdl-file-is-not-valid

  • Chadi Tannous Profile Picture
    Chadi Tannous 1,037 on at
    RE: Visual Studio 2012 reports - can no longer connect to Dynamics 365

    but are you able to use the report from vs 2015 in CRM ?

  • Suggested answer
    Tigger25 Profile Picture
    Tigger25 on at
    RE: Visual Studio 2012 reports - can no longer connect to Dynamics 365

    I have finally got it working in VS2015 - it wasn't working after I had installed Sql Server Data Tools, however, I managed to get it working by then uninstalling and reinstalling the Dynamics 365 Report Authoring Extension.

  • Tigger25 Profile Picture
    Tigger25 on at
    RE: Visual Studio 2012 reports - can no longer connect to Dynamics 365

    Unfortunately Dynamics 365 is not supported in VS2015.

  • Tigger25 Profile Picture
    Tigger25 on at
    RE: Visual Studio 2012 reports - can no longer connect to Dynamics 365

    Tried downloading one of the reports from CRM - it is using the same disco connection string, but I can't even get that report to connect.

  • Suggested answer
    ashlega Profile Picture
    ashlega 34,475 on at
    RE: Visual Studio 2012 reports - can no longer connect to Dynamics 365

    Hi L,

     disco.crm5.dynamics.com;orgname should be the right format (or, at least, that's what's still working for me). Did you try VS2015? I am not sure what's wrong with 2012, but I can't get FetchXml data source for 365 at all in that version (both 2015 and 2012 are installed on my machine)

  • Suggested answer
    BharatPremji Profile Picture
    BharatPremji 2,485 on at
    RE: Visual Studio 2012 reports - can no longer connect to Dynamics 365

    Try downloading one of the reports (the rdl) from CRM and open it up in Visual Studio.

    You should be able to see the connection string it is using and try connecting with that.

    If you still cant connect, then it may be firewall/proxy related?

    Regards

  • Tigger25 Profile Picture
    Tigger25 on at
    RE: Visual Studio 2012 reports - can no longer connect to Dynamics 365

    I'm using the latest version

  • Suggested answer
    BharatPremji Profile Picture
    BharatPremji 2,485 on at
    RE: Visual Studio 2012 reports - can no longer connect to Dynamics 365

    Hi,

    What version of the Report Authoring Extension do you have?

    You may need to get the latest version:

    www.microsoft.com/.../details.aspx

    Bharat

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans