SSRS Report Preview not working for D365 CRM V9 (Solution)

Issue:

If you are trying to preview a FetchXML report in SSRS and you are a facing an issue due to a Sign-In Failure, then the reason for that most probable is due to the reason that you are trying to connect to CRM v9. When we try to connect to a v9 environment using report authoring extensions, the connection fails without any proper error and loops back to organization selection screen or login screen.

Preview Sign-in Issue

If you would try to preview the same report in a v8.x environment then you would be able to preview it successfully.

Reason:

The main reason for this issue is that v9 only uses Transport Layer Security(TLS) 1.2 and TLS 1.0 & 1.1 connections whereas the previous CRM versions still support all TLS connections.

Solution:

  1. The first solution would be to update your Business Intelligence Development Studio(BIDS) to the latest version. Please use the link below:  https://www.microsoft.com/en-us/download/details.aspx?id=56973
  2. The second solution is to make a few changes in your regedit
    1. For systems running on .NET Framework 3.5 on x64-based systems:
      1. HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v2.0.50727
      2. Create a DWORD key
      3. Name: SchUseStrongCrypto
      4. Value: 1
    2. For systems running on .NET Framework 4.5 or later on x64-based systems:
      1. HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\ v4.0.30319
      2. Create a DWORD key
      3. Name: SchUseStrongCrypto
      4. Value: 1
    3. Restart your PC

Note:

  • Please take a backup of your regedit before editing it. Regedit used incorrectly can cause serious problems in your operating system.
  • For x32-based systems do not add the \Wow6432Node in the HKEY paths mentioned.

Your Report should preview fine now!


Share Story :