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.
Ey, so we don’t have a supported way to make a report on the last Dynalmics online version??
Hello,
Why do you say this way is not supported? It is supported but with trick.
Andrew
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)
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
You are the best. Thanks a lot for the great job.
Thank you!!!
Ey, so we don’t have a supported way to make a report on the last Dynalmics online version??
Provided way is supported.
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
Mark,
That’s weird. Can you please check if you can connect to D365 using latest version of XrmToolBox?
Thanks,
Andrew
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)
Hello Marlene,
What version of FetchXml authoring extension do you use?
Andrew
The version of Dynamics 365 Report Authoring Extension is 8.2.0002.0248.
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
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
Hello,
Restart your computer and try installation again.
Andrew
I did so many times same thing happening again and again
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