"Reporting is not enabled"
"One or more server roles are missing from this deployment"
We have tried to re-install the Reporting Extensions for SQL and rebooted the machine several times to no avail.
So, I called MS support and the support engineer sent me CRM 2011 diagnostic tool (do search and you can download it from the net). After we had run the tool we found the following:
================================================================================
SQL: Server Table Information [MSCRM_CONFIG]
================================================================================
>> CRM
[Id......................................]: a29ccb04-21a3-e011-af81-005056a10003
[Name....................................]: CRM
[PodId...................................]: 00000000-0000-0000-0000-000000000000
[Roles...................................]: 86278415
[ScaleGroupId............................]: 00000000-0000-0000-0000-000000000000
[State...................................]: 1
[UniqueifierId...........................]:
[Version.................................]: 5.0.9688.583
[IsDeleted...............................]: False
HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM[CRM_Server_Serviceability_Version]: 5.0.9688.596
HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM[CRM_SrsDataConnector_Serviceability_Version]: 5.0.9688.583
So, to resolve the issue is a simple as check for Widows Updates and you might see the following updates:
Go ahead and install the updates, then reboot the machine and that should fix the issue.
I've done all updates and I'm still getting both of those errors. Reinstalled CRM Reporting multiple times and verified that all Server Roles are installed. I've run the diag tool but I can't make heads or tails of it as of right now. Any help is appreciated, here is a link to a forum post I put up earlier about this: https://community.dynamics.com/crm/f/117/t/107274.aspx
ReplyDelete