Microsoft KB Archive/946753

= You cannot run a report in Microsoft Dynamics CRM 4.0 =

Article ID: 946753

Article Last Modified on 12/27/2007

-

APPLIES TO


 * Microsoft Dynamics CRM 4.0

-



Source: Microsoft Support

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
You cannot run a report in Microsoft Dynamics CRM 4.0. This problem occurs if the following conditions are true:
 * You run Microsoft Dynamics CRM 4.0 on a Microsoft Windows Small Business Server 2003 (Windows SBS) Release 2 (R2) server.

Note Windows SBS R2 contains Microsoft SQL Server 2005 Workgroup Edition.
 * You use an Internet-Facing Deployment (IFD) of Microsoft Dynamics CRM 4.0.



CAUSE
This problem occurs because the Microsoft Dynamics CRM Connector for SQL Server Reporting Services is required to run a report when you use an IFD of Microsoft Dynamics CRM 4.0. However, Microsoft SQL Server 2005 Workgroup Edition does not support custom data extensions. Therefore, the Microsoft Dynamics CRM Connector for SQL Server Reporting Services does not work against Microsoft SQL Server 2005 Workgroup Edition.

Therefore, if you use the IFD of Microsoft Dynamics CRM 4.0, you cannot access the report.



RESOLUTION
To resolve this problem, upgrade Microsoft SQL Server 2005 Workgroup Edition to one of the following editions:
 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Enterprise Edition



MORE INFORMATION
When you use the local intranet, you can configure Kerberos authentication and configure trust for delegation. Therefore, the Microsoft Dynamics CRM Connector for SQL Server Reporting Services is not required when you use local intranet.

The Report Scheduling Wizard does not work when you use Microsoft SQL Server 2005 Workgroup Edition because Microsoft SQL Server 2005 Workgroup Edition does not support snapshots.

Microsoft Dynamics CRM 4.0 only supports Microsoft SQL Server 2005 Workgroup Edition when Microsoft SQL Server 2005 Workgroup Edition is used together with Windows SBS R2.

For more information about Microsoft Dynamics CRM 4.0 IFD setup scenarios, visit the following Microsoft Web site: http://download.microsoft.com/download/8/f/e/8fe2d0e8-62a5-4d7e-b041-5e49a7194ae2/Microsoft Dynamics CRM 4 IFD Setup Scenarios.docx



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 kbexpertiseadvanced kbtshoot kbprb kbnomt kbexpertisebeginner kbmbsmigrate kbexpertiseinter KB946753

-

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

© Microsoft Corporation. All rights reserved.