Microsoft KB Archive/946585

= Error message when you run a report in Microsoft Dynamics CRM 4.0: &quot;Reporting Error. The report cannot be displayed&quot; =

Article ID: 946585

Article Last Modified on 1/3/2008

-

APPLIES TO


 * Microsoft Dynamics CRM 4.0

-



RAPID PUBLISHING
RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION THAT IS CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED TO SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.



SYMPTOMS
Consider the following scenario.
 * On a computer that is running Microsoft SQL Server 2005 Reporting Services and Microsoft SQL Server 2005, you installed Microsoft Dynamics CRM 4.0.
 * You configured the Microsoft Dynamics CRM application pool to run under a domain user account.
 * You configured the SQL Server Reporting Services application pool to run under the network service account.

In this scenario, when you run a report in Microsoft Dynamics CRM 4.0, you receive the following error message:

Reporting Error The report cannot be displayed.

Additionally, you receive an event that resembles the following error message in the report server log file:

w3wp!processing!5!12/10/2007-15:06:18:: e ERROR: Throwing

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'CRM'.

Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'CRM'. ---> System.Data.SqlClient.SqlException: Cannot open database &quot;MSCRM_CONFIG&quot; requested by the login. The login failed.

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.



CAUSE
This problem occurs because the network service account that is running the SQL Server Reporting Services application pool has no access to the Microsoft Dynamics CRM databases.



RESOLUTION
To resolve this problem, grant the permission to the network service account to access to the Microsoft Dynamics CRM databases. To do this, follow these steps:
 * 1) Start SQL Server Management Studio. To do this, click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
 * 2) Expand Security, expand logins, right-click NT AUTHORITY\NETWORK SERVICE, and then click Properties.
 * 3) Click User Mappings.
 * 4) Click to select the check box for the organization database ( _MSCRM), and then click to select the public check box and the CRMReaderRole check box.

Note  is a placeholder for the actual orgaznization name.
 * 1) Click to select the check box next to the configuration database (MSCRM_Config), and then click to select the public check box and the CRMReaderRole check box.
 * 2) Click OK.



MORE INFORMATION
If the SQL Server reporting Services service is running under a domain user account, and the domain user account differs from the network service account that Microsoft Dynamics CRM uses, you receive error messages when you run a report, you can also follow steps in the &quot;Resolution&quot; section to resolve the problem.

If you use the same account for both Microsoft Dynamics CRM and the SQL Server Reporting Services service, the account is given permissions during the Microsoft Dynamics CRM installation. When you install Microsoft Dynamics CRM, the SQL Server Reporting Services service can access to the Microsoft Dynamics CRM databases. This is because the SQL Server Reporting Services service uses the same account as Microsoft Dynamics CRM.

Note The account will have the db_owner role on the Microsoft Dynamics CRM databases.



DISCLAIMER
MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE.

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.

Keywords: kbmbsreports kberrmsg kbexpertisebeginner kbtshoot kbmbsmigrate kbprb kbexpertiseinter KB946585

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.