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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

CRM2016 SRS with SQL 2016 error on setup

(0) ShareShare
ReportReport
Posted on by 25

Hello,
I am about to upgrade our on-premise CRM 2011 to 2016. I went through all the steps of migration, 2013 --> 2015 --> and finally 2016. On 2013 and 2015 I did nto care much about it all. I just installed SQL + CRM and restored the databases of my 2011 organizations. After I have imported theses DB's for new organizaitons in 2013 and 2015 I just went quickly through them afterwards. There are a few JS errors on pages here ant there, but I will take care about them once my migratoin to 2016 is done.
What I am a bit concerned of it reporting. I have not yet installed SRSDataConnector yet. Actually, I tried to install it but during the installation process I get an error like "Install exception.System.Exception: Action Microsoft.Crm.Setup.SrsDataConnector.AddBindingRedirectForRdlHelper failed. ---> System.IO.DirectoryNotFoundException: Could not find a part of the path 'c:\Program Files\Microsoft SQL Server\MSRS13.SQL_CRM2016\Reporting Services\ReportManager\web.config'."
I see that the path "c:\Program Files\Microsoft SQL Server\MSRS13.SQL_CRM2016\Reporting Services\ReportManager\web.config" does not exist indeed. The folder ReportManager is not there.

Now, I have to admit that I am running on Windows 2016 and SQL 2016 Std. But on this page  I have see that SQL 2016 is supported for CRM 2016 if CU2 is installed for SQL 2016. And I have modified ReportingService ports from 80 to 8080 and 443 to 4443. Both run on the same server, I guess this is not a perfect scenario?

On the other hand I am not sure if I even need SRS because here, it states "Dynamics CRM 2011 comes with 54 predefined reports out of the box; 25 of them are main reports and 29 are subreports. If for some reason you don't see any report as shown in the following screenshot, it means Dynamics CRM 2011 Reporting Extensions were not installed." (OK, they talk about 2011 but it should apply to 2016 too. And I do see these reports in my CRM. Now, do I need SRS or not? What we do is to load rdl files generated with ReportServer into CRM as reports.

My questions are:
1. when are CRM Reporting Extensions required and when not? Why do I already see the build-in reports on my vanila organizatioin on CRM 2016, even though my reporting service extensions seem to not be installed? But I have ot admint that some cannot be displayed, though. Is this maybe because of the missing reporting service extensions? Actually I don't think so, I feel like if install a full CRM server, SRS is also installed, since if I choose to install SRS separatelly, it prompts me to unistall or repair it.
2. can anyone tell me what's wrong with the setup error mentioned above?

kind regards,
Dieter Tontsch
mobileX AG

*This post is locked for comments

I have the same question (0)
  • Dieter Tontsch Profile Picture
    25 on at

    Hello,

    in the meantime I have digged a bit further and I have overlooked one thing re. CRM 2016 compatibility with SQL 2016. Only build 8.2.0.0749 is compatible to SQL 2016. And due to the fact that CRM 2016 also is renamed into Dynamics 365, this sounded to me like only the cloud version is compatible. But in the mean time I have installed the very latest build of CRM server (CRM2016-Server-KB3205084-ENU-Amd64.exe) and reporting service extensions (CRM2016-Srs-KB3205084-ENU-Amd64.exe), so called Update 2 - my CRM organizations are now on build 8.2.0.0749. But even though I could successfully install this latest SRS, Deployment Manager still shows "Reporting is not enabled" - I shall install "Dynamics 365 Reporting Extensions for SQL" which I did. Any idea how I can fix my CRM in terms of getting reporting to fly?

    I read several articles on how to install Reporting Extensions, but in my case only the CRM2016-Srs-KB3205084-ENU-Amd64.exe works, the older ones do not because they seem to not support SQL 2016.

  • Suggested answer
    Community Member Profile Picture
    on at

    The CRM 2016 Compatibility List does indicate CRM 2016 can be installed on SQL 2016, but as the list indicates - CU2 for SQL Server 2016 must be installed. However, as Hitachi points out - a method of pointing to the .cab files for the CU wasn't obvious, so they just moved the SSRS web.config file to the location that the SrsConnector was looking for it:  <driveletter>:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services and without CU2 the CRM SrsConnector was successfully installed. I'm a little disappointed that when an install is initiated, we take the time to click on 'Obtain Setup Updates' (sic) during the install - and Microsoft hasn't updated those setup updates to resolve this issue, but not surprised.

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…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans