web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / SSRS reports not worki...
Customer experience | Sales, Customer Insights,...
Suggested Answer

SSRS reports not working on SQL 2016 for CRM 2016 image shown below

(0) ShareShare
ReportReport
Posted on by Waqas Latif 565

SQL 2016 v18.4, 

We have recently installed new instance of CRM 2016 with SQL 2016 v 18.4 but SSRS reports are not working, i have also installed the extension kb3154952.

Same is working in SQL 2012 R2 with CRM 2016 is this related to version, can anyone help how this can be fixed? CRM version is 8.1.0.381

SSRS Not redenering on SQL 2016-CRM 2016

I have the same question (0)
  • Suggested answer
    Saad Kabarousse Profile Picture
    Saad Kabarousse 734 on at

    Hello my friend,

    First of all you should open the reports in your visual studio solution and point the data sources on the CRM 2016 data base.

    Test them on your visual studio and make sure thay are working fine. after that regenerate the rdl and deploy them one more time in CRM.

    If still have problem please post the error messag ethat is deplayed.

    Hope this works.

  • Waqas Latif Profile Picture
    Waqas Latif 565 on at

    Hi Saad,

    Actually there is no error on the screen or in the event viewer,i saw in the report builder the report is working fine and parameters are shown in a normal way.

    The above image i showed is the issue, where the view report button and even parameters are not rendered and clickable.

    The only error i see is below in event viewer but its not frequent.

    Report Server (MSSQLSERVER) cannot load the TERADATA extension.

    Report Server (MSSQLSERVER) cannot load the SQLPDW extension.

    Report Server (MSSQLSERVER) cannot load the ORACLE extension.

    Any suggestions please ?

  • Suggested answer
    Saad Kabarousse Profile Picture
    Saad Kabarousse 734 on at

    Hello my friend,

    i would suggest :

    1- Log in to the report server where ur reports are deployed, and go to servername/.../ and go to one of your reports details and verify each one of the connection  managers , you will find a 'TEST CONNECTION' button linked to each one of them. i think this may be the main problem.

    2- enabling Tracer and try opening the report to see more details on the error.

    Hope this helps my friend.

  • Waqas Latif Profile Picture
    Waqas Latif 565 on at

    I tried first point but all same

    then i tried your second suggestion and it showed me an error of the organization you are trying to connect is disabled.

    I have two organizations here one is disabled the default one the other one was imported into the system which is production.

    How can i solve this problem? I dont want to enable the other organization but shouldnt the report server be working with multiple instance in the CRM ?

    getting closer to the issue

  • Waqas Latif Profile Picture
    Waqas Latif 565 on at

    Hi Saad,

    Found out the issue but its strange.

    We have two environments in our setup.

    One is default installation vanila version, the other is the imported organization which we are using as primary.

    The default organization was disabled hence the reports were not working in the other imported organization.

    When i enabled that one the reports are working fine and with proper data of new imported organization data.

    Any solution to this strange behavior?

    Thanks in advance !

  • Seniz Akbulut Profile Picture
    Seniz Akbulut 5 on at

    Hi Waqas Latif

    I'm facing a problem similar to the one you describe.

    If you have reached the solution, can you offer a few ideas about the solution?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 196 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 129

#3
CU11031447-0 Profile Picture

CU11031447-0 100

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans