We did a new install for CRM 2011 RTM on a machine that has Windows 2008 R2 Ent. and SQL 2008 R2 Ent. The installation went fine and we did not encounter any issues.However, when we launched
Microsoft CRM Deployment Manager we got the two warning messages:
"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.