Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM forum / Microsoft Dynamics 365...
Microsoft Dynamics CRM forum
Unanswered

Microsoft Dynamics 365 Reporting Extensions must be installed on SQL Server Reporting Services for reports to work

(1) ShareShare
ReportReport
Posted on by Martin Dolezel 20

Hi,

I  would like to import my Organization during the upgrade from version 8.2 to 9.00034. I just Installed MS Dynamic CRM Server aplication and SQL Server Reporting services and CRM Dynamic Extensions on another database server.
Everything works OK.  Like Reporting Service URL and Reporting Service Reports URL on both servers.

But when I try import my organization or try to create new it is not possible.

I have this Check blocker

Error| Check SrsExtensionsValidator : Failure: Microsoft Dynamics 365 Reporting Extensions must be installed on SQL Server Reporting Services for reports to work.

pastedimage1638393901378v1.pngpastedimage1638393920080v2.png

Both version are same CRM Server and CRM Extencions on db Server 9.00034

Many times I removed and changed the encryption keys in Reporting Services Manager, but that didn't help.

Reporting Services account is another than CRM Admin account and both have owner rights on Reporting and Organization databases and are members in this AD groups PrivReportingGroup, PrivUserGroup


What else can I try?

thanks

Categories:
Install and Upgrade
  • Martin Dolezel Profile Picture
    Martin Dolezel 20 on at
    RE: Microsoft Dynamics 365 Reporting Extensions must be installed on SQL Server Reporting Services for reports to work

    Hi Efrain,

    thanks for your reply.

    In DMSnapin  is only this

    22:15:48|   Info| DoCreateCheck Started
    22:15:49|   Info| DoCreateCheck Ended
    22:15:49|   Info| Check CrmDatabaseFilesValidator: Success
    22:15:49|   Info| Group Microsoft SQL Server Reporting Services
    22:15:49|   Info| Check ReportingUrlValidator: Success
    22:15:49|   Info| UrlAccessValidator linking to help topic: go.microsoft.com/.../
    22:15:49|   Info| Check ExistingRSValidator: Success
    22:15:49|  Error| Check SrsExtensionsValidator : Failure: Microsoft Dynamics 365 Reporting Extensions must be installed on SQL Server Reporting Services for reports to work.
    22:15:49|Verbose| Validation ran.
    22:15:49|Verbose| Validation completed.

    After about a day it started to work on its own. The only thing that comes to mind is automatic synchronization between AD controllers. But I am not an AD expert. 

     
  • edmunch Profile Picture
    edmunch on at
    RE: Microsoft Dynamics 365 Reporting Extensions must be installed on SQL Server Reporting Services for reports to work

    What do you see in the DMSnapin logs and also on the server Event Viewer files for the time this fails?  It might give us more information on where to look?

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans