Microsoft Dynamics 365 v9.0: How to fix connectivity issues between SSDT + Report Authoring Extension and Dynamics 365

14/02/201815/02/2018 | by Andrew Butenko

At the moment (February 14, 2018) Microsoft hasn’t released version of Report Authoring Extension that supports both v9.0 and enforced TLS 1.2. This post will help people who develops reports for latest Dynamics 365 v9.0 using SQL Server Data Tools and FetchXml Authoring Extension.

This is how it looks now when you try to run report against v9.0 – you enter credentials, click “Login”, choose correct instance, click “Login” and you sent back to first form with additional message at the bottom of form:

Here are steps how to fix it:

Download and install Fiddler if you still don’t have it.
Run Fiddler. Open Tools -> Options -> HTTPS:

3. Click on highlighted text after “Protocols” label and add ;tls1.2 text at the end and click “OK”:

After that run report and ensure that it works as expected.

19 Comments

neco says:

03/04/2018 at 9:36 am

Ey, so we don’t have a supported way to make a report on the last Dynalmics online version??

Reply
1. Andrew Butenko says:
  
  03/04/2018 at 1:12 pm
  
  Hello,
  Why do you say this way is not supported? It is supported but with trick.
  Andrew
  
  Reply
2. Sabindas says:
  
  17/01/2019 at 10:10 am
  
  Hi , Uninstall BIDS and install the latest version of BIDS(v9), it will resolve the issue.
  
  https://www.microsoft.com/en-us/download/details.aspx?id=56973
  
  Dynamics 365, version 9.0 Report Authoring Extension (with SQL Server Data Tools support)
  
  Reply
  1. Andrew Butenko says:
    
    17/01/2019 at 2:18 pm
    
    Sabindas,
    I checked it and I was not satisfied with results because labels for optionsets or lookups are not returned with dataset. I plan to write post on it and get in touch with PG to understand why.
    That’s why I would not recommend using new extension until it’s not fixed.
    Andrew
    
    Reply
Pingback: SSRS Reports for Dynamics 365 Using FetchXML – My Learnings
Tall Mirror says:

05/12/2018 at 7:23 am

You are the best. Thanks a lot for the great job.

Reply
Mateo Bianco says:

09/12/2018 at 9:37 pm

Thank you!!!

Reply
Vaikuntha says:

22/01/2019 at 6:40 am

Ey, so we don’t have a supported way to make a report on the last Dynalmics online version??

Reply
1. Andrew Butenko says:
  
  22/01/2019 at 12:59 pm
  
  Provided way is supported.
  
  Reply
Mark Pitts says:

30/07/2019 at 5:28 pm

I’m trying to run my report, from SSDT, against, “Version 1710 (9.1.0.6631) online “.
1. added tls 1.2 to HTTPS protocol, via fiddler.
2. continue running Fiddler
3. when I run the report, from SSDT, I am subject to the endless loop of choosing an instance, and login.

Any thoughts?
Cheers,
Mark

Reply
1. Andrew Butenko says:
  
  30/07/2019 at 5:37 pm
  
  Mark,
  That’s weird. Can you please check if you can connect to D365 using latest version of XrmToolBox?
  Thanks,
  Andrew
  
  Reply
Marlene Roman says:

18/12/2019 at 6:28 pm

Hello All.

I tried applying this trick and it did not work for me. I do have the latest version of BIDS(v9).

Running Visual Studio 2015 as well as SQL Server Data Tools for VS 2015. Any additional thoughts on this?

This is what it gets recorded in the error log

Source : System
Method : GetResponse
Date : 12/18/2019
Time : 12:59:52 PM
Error : The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
Stack Trace : at System.Net.HttpWebRequest.GetResponse()
at Microsoft.Xrm.Tooling.Connector.DeviceIdManager.ExecuteRegistrationRequest(String url, DeviceRegistrationRequest registrationRequest)
at Microsoft.Xrm.Tooling.Connector.DeviceIdManager.RegisterDevice(Guid applicationId, Uri issuerUri, LiveDevice device)
at Microsoft.Xrm.Tooling.Connector.DeviceIdManager.RegisterDevice(Guid applicationId, Uri issuerUri, String deviceName, String devicePassword)
at Microsoft.Xrm.Tooling.CrmConnectControl.CrmConnectionManager.GenerateDeviceCreds()
at Microsoft.Xrm.Tooling.CrmConnectControl.CrmConnectionManager.ValidateServerConnection(CrmOrgByServer selectedOrg)

Reply
1. Andrew Butenko says:
  
  18/12/2019 at 6:37 pm
  
  Hello Marlene,
  What version of FetchXml authoring extension do you use?
  Andrew
  
  Reply
  1. Marlene Roman says:
    
    18/12/2019 at 7:34 pm
    
    The version of Dynamics 365 Report Authoring Extension is 8.2.0002.0248.
    
    Reply
    1. Andrew Butenko says:
      
      18/12/2019 at 7:46 pm
      
      Marlene,
      I haven’t tried this approach for a year because I had no reports related work.
      There is a chance that Microsoft changed something on their backend so this trick doesn’t work anymore.
      Alternative way – try to uninstall 8.2 and install 9.0 version of tool – https://www.microsoft.com/en-us/download/details.aspx?id=56973 because it uses later version of sdk assemblies where TLS1.2 is addressed.
      Thanks,
      Andrew
muralikrishna says:

28/05/2020 at 3:09 pm

Hi,i am tried to install reporting authoring extension i am getting error log like this as below.

20:06:27| Info| === Setup bootstrap logging started 5/28/2020 8:06:27 PM ===
20:06:27| Info| Bootstrap version: 8.2.2.248.
20:06:27| Info| User: Admin.
20:06:30| Error| Reboot required — Key Found: HKCU\Software\Microsoft\Windows\CurrentVersion\RunOnce contains Application Restart #8
20:06:43| Error| Setup cannot continue because there is a pending restart required. Restart the computer and then try running Setup again., Error, OK
20:06:43| Info| InputResult: OK
20:06:43| Info| Clean up the BITS downloader.

20:13:41| Info| === Setup bootstrap logging started 5/28/2020 8:13:41 PM ===
20:13:41| Info| Bootstrap version: 8.2.2.248.
20:13:41| Info| User: Admin.
20:13:43| Error| Reboot required — Key Found: HKCU\Software\Microsoft\Windows\CurrentVersion\RunOnce contains Application Restart #8
20:14:04| Error| Setup cannot continue because there is a pending restart required. Restart the computer and then try running Setup again., Error, OK
20:14:04| Info| InputResult: OK
20:14:04| Info| Clean up the BITS downloader.

20:17:19| Info| === Setup bootstrap logging started 5/28/2020 8:17:19 PM ===
20:17:19| Info| Bootstrap version: 8.2.2.248.
20:17:19| Info| User: Admin.
20:17:19| Error| Reboot required — Key Found: HKCU\Software\Microsoft\Windows\CurrentVersion\RunOnce contains Application Restart #8
20:18:29| Error| Setup cannot continue because there is a pending restart required. Restart the computer and then try running Setup again., Error, OK
20:18:29| Info| InputResult: OK
20:18:30| Info| Clean up the BITS downloader.

20:20:54| Info| === Setup bootstrap logging started 5/28/2020 8:20:54 PM ===
20:20:54| Info| Bootstrap version: 8.2.2.248.
20:20:54| Info| User: Admin.
20:20:54| Error| Reboot required — Key Found: HKCU\Software\Microsoft\Windows\CurrentVersion\RunOnce contains Application Restart #8
20:21:19| Error| Setup cannot continue because there is a pending restart required. Restart the computer and then try running Setup again., Error, OK
20:21:19| Info| InputResult: OK
20:21:19| Info| Clean up the BITS downloader.

20:31:33| Info| === Setup bootstrap logging started 5/28/2020 8:31:33 PM ===
20:31:33| Info| Bootstrap version: 8.2.2.248.
20:31:33| Info| User: Admin.
20:31:35| Error| Reboot required — Key Found: HKCU\Software\Microsoft\Windows\CurrentVersion\RunOnce contains Application Restart #8
20:31:44| Error| Setup cannot continue because there is a pending restart required. Restart the computer and then try running Setup again., Error, OK
20:31:44| Info| InputResult: OK
20:31:44| Info| Clean up the BITS downloader.

21:36:58| Info| === Setup bootstrap logging started 5/28/2020 9:36:58 PM ===
21:36:58| Info| Bootstrap version: 8.2.2.248.
21:36:58| Info| User: Admin.
21:36:58| Error| Reboot required — Key Found: HKCU\Software\Microsoft\Windows\CurrentVersion\RunOnce contains Application Restart #8
21:37:12| Error| Setup cannot continue because there is a pending restart required. Restart the computer and then try running Setup again., Error, OK
21:37:12| Info| InputResult: OK
21:37:12| Info| Clean up the BITS downloader.

21:37:19| Info| === Setup bootstrap logging started 5/28/2020 9:37:19 PM ===
21:37:19| Info| Bootstrap version: 8.2.2.248.
21:37:19| Info| User: Admin.
21:37:20| Error| Reboot required — Key Found: HKCU\Software\Microsoft\Windows\CurrentVersion\RunOnce contains Application Restart #8
21:37:22| Error| Setup cannot continue because there is a pending restart required. Restart the computer and then try running Setup again., Error, OK
21:37:23| Info| InputResult: OK
21:37:23| Info| Clean up the BITS downloader.

23:31:32| Info| === Setup bootstrap logging started 5/28/2020 11:31:32 PM ===
23:31:32| Info| Bootstrap version: 8.2.2.248.
23:31:32| Info| User: Admin.
23:31:34| Error| Reboot required — Key Found: HKCU\Software\Microsoft\Windows\CurrentVersion\RunOnce contains Application Restart #8
23:31:48| Error| Setup cannot continue because there is a pending restart required. Restart the computer and then try running Setup again., Error, OK
23:31:48| Info| InputResult: OK
23:31:48| Info| Clean up the BITS downloader.

23:36:26| Info| === Setup bootstrap logging started 5/28/2020 11:36:26 PM ===
23:36:26| Info| Bootstrap version: 8.2.2.248.
23:36:26| Info| User: Admin.
23:36:26| Error| Reboot required — Key Found: HKCU\Software\Microsoft\Windows\CurrentVersion\RunOnce contains Application Restart #8

Reply
1. Andrew Butenko says:
  
  28/05/2020 at 3:12 pm
  
  Hello,
  Restart your computer and try installation again.
  Andrew
  
  Reply
muralikrishna says:

28/05/2020 at 3:15 pm

I did so many times same thing happening again and again

Reply
1. Andrew Butenko says:
  
  28/05/2020 at 3:20 pm
  
  If you did the restart and Key is still there I would recommend to open HKCU\Software\Microsoft\Windows\CurrentVersion\RunOnce using regedit and delete the key.
  Andrew
  
  Reply