Skip to main content

Notifications

Service | Customer Service, Contact Center, Fie...
Suggested answer

Getting error while connecting SSRS report to Dynamics data

Posted on by 10

Hello All,

I want to update one of my existing SSRS report created for Dynamics. This report was developed before 4 years.

To make it simple I created a new solution and tried to create a new report. Here the system ask me to provide the connection string where I provide below url-

disco.crm.dynamics.com/;<<OrgID>>               (In the above url I have replaced the OrgID with my Org unique Id. )

after clicking Next it shows a form to mention deployment type and other details where I am adding the dynamics user details.

after adding above details it is showing me the connection error.

pastedimage1668606069579v1.png

Note: I have installed the latest version of Dynamics Report authoring extension. previously I was having the older version after which I uninstall and reinstall it. in this process I also clean the keys from the registry. still I am getting the same error while establishing the connection.

Any help would be highly appreciated.

Regards

Shruti Vyas 

  • ShrutiVyas Profile Picture
    ShrutiVyas 10 on at
    RE: Getting error while connecting SSRS report to Dynamics data

    I have selected Prompt for Credentials options. It ask me the credentials and after providing the credentials it shows below screen-

    pastedimage1669014781151v1.png

    In the above screen I am providing user name and password and after clicking on Login it is showing below error-

    pastedimage1669015066138v1.png

    I am stuck here.

  • Steve Zhao2 Profile Picture
    Steve Zhao2 on at
    RE: Getting error while connecting SSRS report to Dynamics data

    Hi ShrutiVyas,

    Which option you select in Credentials? If you select name and password, please check it.

  • ShrutiVyas Profile Picture
    ShrutiVyas 10 on at
    RE: Getting error while connecting SSRS report to Dynamics data

    Thanks Steve for your reply.

    I tried with Organization URL but still getting the same error.

  • Suggested answer
    Steve Zhao2 Profile Picture
    Steve Zhao2 on at
    RE: Getting error while connecting SSRS report to Dynamics data

    Hi ShrutiVyas,

    You should type your organization url here:

    pastedimage1668673331605v1.png

    You could find your organization url at PPAC->Environments->Your environment:

    pastedimage1668673473461v4.png

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans