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

Getting error while connecting SSRS report to Dynamics data

(0) Share

Report

Posted on by ShrutiVyas

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.

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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Steve Zhao2 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi ShrutiVyas,

You should type your organization url here:

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

Was this reply helpful? Yes No
ShrutiVyas 10 on at

Like (0)

Report
Copy link

Link copied!

Thanks Steve for your reply.

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

Was this reply helpful? Yes No
Steve Zhao2 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi ShrutiVyas,

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

Was this reply helpful? Yes No
ShrutiVyas 10 on at

Like (0)

Report
Copy link

Link copied!

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

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

I am stuck here.

Was this reply helpful? Yes No