You cannot run a report in Microsoft Dynamics CRM 4.0

Article translations Article translations
Article ID: 946753 - View products that this article applies to.
  
Expand all | Collapse all

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 server that is running Microsoft Windows Small Business Server 2003 R2 (Windows SBS).

    Note Windows SBS 2003 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, 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 SQL Server 2005 Workgroup Edition. If you use an IFD of Microsoft Dynamics CRM 4.0, you cannot access the report.

Resolution

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

More information

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

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

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

Properties

Article ID: 946753 - Last Review: January 24, 2013 - Revision: 6.0
Applies to
  • Microsoft Dynamics CRM 4.0
Keywords: 
kbmbsreports kbexpertiseadvanced kbtshoot kbprb kbexpertisebeginner kbmbsmigrate kbexpertiseinter KB946753

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com