So recently while working on installing and configuring a new implementation of Microsoft Dynamics CRM 2011, I ran across an error where the SSRS Data Connector/Reporting Extensions would not install on the SQL Server. Shortly after you start installation, you get this error:
Microsoft Dynamics CRM Reporting Extensions Setup
Error: Microsoft.Crm.Setup.SrsDataConnector.RegisterServeAction Failed.
Requested value ‘Geo’ was not found.
So what the heck does that mean, Microsoft? “Requested value ‘Geo’?”
It turns out that this error has been around for a while – since at least CRM Update Rollup 6, if not before.
Essentially, to make a long story short, the SSRS Data Connector/Reporting Extensions install file became orphaned on the Dynamics CRM 2011 disk. At one point, Microsoft updated the Dynamics Server install files to UR6, but did not do the same with the SSRS install file.
In order to correct this oversight, you actually need to start the installation of SSRS, cancel it, then install Update Rollup 6. Through many installs since then, I’ve found this is the most efficient method to complete the task:
1. Begin the installation of the SSRS connector from the installation media: \Server\amd64\SrsDataConnector > right-click on “SetupSrsDataConnector.exe” > Choose “Run as Administrator”.
2. Run through the program setup, until you get the following error message:
3. Click the Cancel button, and finish the installation. It will fail; this is fine. The point is that it has unpacked the installation files.
4. Run Windows Update and look for “Update Rollup 6 for Microsoft Dynamics CRM 2011 Reporting Extensions (KB2600640)”. Alternately, you can download the update manually here.
Note: Install just this update. Do not install any other, newer CRM update rollups at the same time.
5. Once the UR6 has installed successfully, navigate to “C:\Program Files\Microsoft Dynamics CRM Reporting Extensions” (or whatever install location you chose in Step 1) > right-click on “SetupSrsDataConnector.exe”, and chose “Run as Administrator”.
6. Chose the option to “Repair” the installation.
Once the Repair is completed, SSRS should be working and ready to go! Don’t forget to run Windows Update to install the rollups so that it is at the same version as the rest of your CRM environment.
Note: If you have had a failed install at any point with the exception of Steps 2-3 above, you may get additional or other error messages. Generally, a reboot of the server clears these errors.