"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.