Blog, Development, Howto, Reports

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

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:

  1. Download and install Fiddler if you still don’t have it.
  2. 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

      1. 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

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

  2. 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

    1. Mark,
      That’s weird. Can you please check if you can connect to D365 using latest version of XrmToolBox?
      Thanks,
      Andrew

  3. 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)

        1. 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

  4. 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

    1. 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

Leave a Reply to Mateo Bianco Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.