Just a quick entry in case you are trying to solve a problem when attempting to install CRM Reporting Extensions. You might encounter a situation where you specify the SQL Server machine or instance name, but proceeding to select the SSRS instance produces a blank list.
So you need to install Reporting Extensions AFTER you’ve successfully installed Dynamics CRM. Partially this is so that the Organisation and associated reports (if any) are correctly published to SSRS. Aside from this, also verify the following…
First thing to check is that you’re installing the Reporting Extensions on the SSRS/SQL location and NOT the CRM Application server(s).
If so far everything is correct, check the log file for the installer. You can specify a location other than the default, invoke the installer from a command prompt like this:
SetupSrsDataConnector /Q /CONFIG c:\temp\install-config.xml /L c:\temp\log.txt
If you find the following in the installer log:
- “Could not find a local RS instance corresponding to the reporting url http:///<reportserver> for organization <org name>”
- “Organization <org name> does not have reports published”
It could be that you’re trying to install against a 32 bit version of SQL Server, or an unsupported edition (see supported editions and how to check your edition of SQL Server in the References, below).
You can also use the command line to specify a configuration file, here’s an example:
<crmsetup>
<srsdataconnector>
<configdbserver></configdbserver>
<autoupdateconfigdb>1</autoupdateconfigdb>
<reportserverurl>http://servername/Reportserver</reportserverurl>
<autogroupmanagementoff>0</autogroupmanagementoff>
<instancename>Titan</instancename>
<configsku>OnPremise</configsku>
<!– Set enabled = true for DB webstore integration. Set configdb=”true” for config db webstore integration–>
<webstore enabled=”false” configdb=”false” />
<monitoring>
<!– Monitoring service account name and password. It can not be local system or network service account –>
<serviceaccountname></serviceaccountname>
<serviceaccountpassword></serviceaccountpassword>
</monitoring>
</srsdataconnector>
</crmsetup>
References
Microsoft Dynamics CRM reporting requirements – https://technet.microsoft.com/en-us/library/hh699754.aspx
How to determine the version, edition and update level of SQL Server and its components – https://support.microsoft.com/en-au/kb/321185
Install Microsoft Dynamics CRM Reporting Extensions using a command prompt – https://technet.microsoft.com/en-us/library/hh699725.aspx
