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

Notifications

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 73 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 43 Most Valuable Professional

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans