CRM Reporting Extensions – SSRS not listed


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:

image

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


About Rob Sanders

IT Professional and TOGAF 9 certified architect with nearly two decades of industry experience, 18 years in commercial software development and 11 years in IT consulting. Check out the "About Rob" page for more information.

Leave a comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>