Issue connecting dynamics 365 v9.0 from bids for ssrs reports

(1) Share

Report

Posted on by manojd

1,397

Hi All,

As we all aware that effective last week Microsoft has mandated TLS1.2 for Dynamics 364 v9.0, i am not able to connect the CRM online instance from visual studio for creating new report via fetch XML

Did anyone has same issue & found any solutions then request to help me

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (2)

Suggested answer

jestuder 158 on at

Like (1)

Report

What version of BIDS and Report Authoring Extension do you have installed? Try updating those. I just tested this in my setup and was able to connect to a v9 org. Here is a blog explaining the login process:

community.dynamics.com/.../ssrs-reports-for-dynamics-365-using-fetchxml

Here is my setup:

Visual Studio 2015

Report Authoring Extension v8.2.0002.0248

SQL Server Data Tools (BIDS) v14.0.61707.300

I will say that after I entered my url and credentials I did get an error message saying cached org couldn't be found. I clicked ok and then checked the box to list the organizations. I then choose the one I wanted to connect to and I was able to proceed.

Was this reply helpful? Yes No
Alok Singh 910 on at

Like (0)

Report

Hi Manoj,

Did you manage to get any solution for report creation as I am also facing the same issue for one of my client?

Regards,

Alok

Was this reply helpful? Yes No
Verified answer

manojd 1,397 on at

Like (0)

Report

Hi Alok,

yes my problem is solved by following the URL given below

mscrm365.blogspot.sg/.../dynamics-crm-v9-connection-error-in.html

Was this reply helpful? Yes No
Aminovski on at

Like (0)

Report

Hi Manoj,

I've encountred the same issue than yours with SSRS. I've uninstalled Report Authoring Extension as mentioned in the link you've shared but I still have the same problem. Do you have a V9 installation file for Report Authoring Extension? How did you get it?

Thank you.

Was this reply helpful? Yes No
Verified answer

manojd 1,397 on at

Like (0)

Report

Hi Amine,

follow the link below for the latest Report Authoring

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

Was this reply helpful? Yes No
Aminovski on at

Like (0)

Report

Hi Manoj,

Thank you for your answer. I've already tried the version of this link and it's a V8.2 so it doesn't work.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Guys,

If you are still facing issues in connecting SSRS report with CRM Online, please do the following

On the machine where VS is installed, open regedit using the Run Window.

1) Once the Registry Editor, open: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v4.0.30319

2) Right click on the v4.0.30319 folder and select New, and then select DWORD.

3) Provide the name as SchUseStrongCrypto and the Value as 1.

4) Restart your machine.

Was this reply helpful? Yes No
manojd 1,397 on at

Like (0)

Report

Hi,

above mentioned steps will solve the issue but is not recommended

Better you follow this URL mscrm365.blogspot.sg/.../dynamics-crm-v9-connection-error-in.html & also download latest CRM SDK & Report Authoring tool from here www.microsoft.com/.../details.aspx

Was this reply helpful? Yes No
Feridun Kadir 1,705 Most Valuable Professional on at

Like (0)

Report

Version 9.0 of the report authoring tool can be found here, https://www.microsoft.com/en-us/download/confirmation.aspx?id=56973

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks sir, After installed 9.0 version its working fine.

Was this reply helpful? Yes No