Export (0) Print
Expand All

Microsoft Dynamics CRM 2015 Reporting requirements

Microsoft Dynamics CRM Reporting Extensions are data processsing extensions that are installed on the Microsoft SQL Server Reporting Services server. The Microsoft Dynamics CRM Reporting Extensions accept the authentication information from Microsoft Dynamics CRM Server and passes it to the Microsoft SQL Server Reporting Services server.

Microsoft Dynamics CRM Reporting Extensions Setup includes two data processing extensions: Fetch data processing extension and SQL data processing extension. By default, these extensions are installed during Microsoft Dynamics CRM Reporting Extensions Setup.

  • The Fetch data processing extension is required to create, run, and schedule Fetch-based reports.

  • The SQL data processing extension is required to run and schedule the default (out-of-box) or SQL-based custom reports inMicrosoft Dynamics CRM.

You don’t need Microsoft Dynamics CRM Reporting Extensions to run Microsoft Dynamics CRM. However, if you want to create, use, or schedule reports in Microsoft Dynamics CRM, you must install Microsoft Dynamics CRM Reporting Extensions. Additionally, you have to install it if you want to create an organization or import an organization, such as when you migrate from an earlier version of Microsoft Dynamics CRM by using Deployment Manager.

SQL Server Reporting Services

Microsoft SQL Server Reporting Services is required for reporting features in Microsoft Dynamics CRM.

The following Microsoft SQL Server editions can be used for Microsoft Dynamics CRM reporting and must be installed on a Windows Server 2012 (x64 RTM or R2) 64-bit-based computer, running and available for Microsoft Dynamics CRM:

  • Microsoft SQL Server 2014, Enterprise, 64-bit

  • Microsoft SQL Server 2014, Business Intelligence, 64-bit

  • Microsoft SQL Server 2014, Standard, 64-bit

  • Microsoft SQL Server 2014, Developer, 64-bit (for non-production use only)

  • Microsoft SQL Server 2012, Enterprise, 64-bit SP1

  • Microsoft SQL Server 2012, Business Intelligence, 64-bit SP1

  • Microsoft SQL Server 2012, Standard, 64-bit SP1

  • Microsoft SQL Server 2012, Developer, 64-bit SP1 (for non-production use only)

ImportantImportant
  • 32-bit versions of Microsoft SQL Server 2012 Reporting Services are not supported for this version of Microsoft Dynamics CRM.

  • SQL Server Compact or Microsoft SQL Server Express editions are not supported for use with Microsoft Dynamics CRM Server.

  • Microsoft SQL Server 2008 versions are not supported for use with Microsoft Dynamics CRM Server 2015.

  • Using a Microsoft SQL Server 2012 Reporting Services server running in SharePoint mode is not supported with Microsoft Dynamics CRM. For more information about Microsoft SQL Server 2012 Reporting Services SharePoint mode, see Install Reporting Services SharePoint Mode.

Microsoft Dynamics CRM Reporting Extensions requirements

The Microsoft Dynamics CRM Reporting Extensions component has the following requirements:

  • You must complete Microsoft Dynamics CRM Server Setup before you run Microsoft Dynamics CRM Reporting Extensions Setup.

  • You can install and run Microsoft Dynamics CRM Reporting Extensions on only one instance of Microsoft SQL Server Reporting Services on a computer.

  • The identity account running the instance of Microsoft SQL Server Reporting Services where the Microsoft Dynamics CRM Reporting Extensions are running can’t be the local system or a virtual account. This is required for Microsoft Dynamics CRM reporting to work because the identity account must be added to the PrivReportingGroup Active Directory security group that is used by Microsoft Dynamics CRM.

  • Separate deployments of Microsoft Dynamics CRM cannot share one Microsoft SQL Server Reporting Services server. However, a single deployment of Microsoft Dynamics CRM that has multiple organizations can use the same Microsoft SQL Server Reporting Services server.

  • You must run the Microsoft Dynamics CRM Reporting Extensions Setup on a computer that has a supported version of Microsoft SQL Server Reporting Services installed. More information: SQL Server Reporting Services

  • For smaller data sets and fewer users, you can use a single-server deployment or a multiple-server deployment. With larger datasets or more users, performance decreases quickly when complex reports are run. Use a multi-server deployment with one computer that is running SQL Server for Microsoft Dynamics CRM, and another server for Microsoft SQL Server Reporting Services.

Microsoft Dynamics CRM Reporting Authoring Extension requirements

Microsoft Dynamics CRM Report Authoring Extension is required to author fetch-based reports by using SQL Server Data Tools.

You must install the Microsoft Dynamics CRM Report Authoring Extension on a PC that has the following software.

  • Microsoft Visual Studio 2012 or Microsoft Visual Studio 2010.

    noteNote
    Report Authoring Extension is not compatible with Microsoft Visual Studio 2013.

  • SQL Server Data Tools (SSDT) installed with either Microsoft Visual Studio 2012 or Microsoft Visual Studio 2010. More information: Install SQL Server Data Tools

  • If your organization uses Microsoft Office 365, make sure that the computer on which the Microsoft Dynamics CRM Report Authoring Extension is installed also has the Microsoft Online Services Sign-in Assistant installed on it. If Microsoft Online Services Sign-in Assistant is already installed, check the registry key SOFTWARE\Microsoft\MSOIdentityCRL and make sure that the TargetDir registry key in MSOIdentityCRL contains msoidcli.dll.

See Also

Send comments about this article to Microsoft.

© 2014 Microsoft Corporation. All rights reserved.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft