Error message when you run a report in Microsoft Dynamics CRM: "Reporting Services Error" or "An Error has occurred during report processing" or "Login failed for user '(null)'" (909509)


The information in this article applies to:

  • Microsoft CRM 3.0

SYMPTOMS

When you run a report in Microsoft Dynamics CRM 3.0, you receive one of the following error messages.

Error message 1
Reporting Services Error.
Error message 2
An Error has occurred during report processing. Cannot create a connection to data source 'CRM'.
Error message 3
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
This problem occurs after you upgrade the operating system of the server that is running Microsoft Dynamics CRM or Microsoft SQL Server. Specifically, you upgrade the operating system from Microsoft Windows Server 2000 to Microsoft Windows Server 2003.

CAUSE

The problem occurs because the Trust computer for delegation property is not enabled for SQL Server.

RESOLUTION

To resolve this problem, follow these steps:
  1. Log on to a domain controller in the Microsoft Dynamics CRM domain as a user who has a domain administrator role.
  2. Click Start, point to Administrative Tools, and then click Active Directory Users and Computers.
  3. Expand the domain node, and then expand the group unit or the organization unit that has the computer that contains the SQL Server databases for Microsoft Dynamics CRM.
  4. Right-click the computer that contains the SQL Server databases for Microsoft Dynamics CRM, and then click Properties.
  5. On the General tab, select the Trust computer for delegation check box.
  6. Restart the SQL Server service.
    1. Log on to SQL Server.
    2. Click Start, point to Administrative Tools, and then click Services.
    3. Right-click MSSQLSERVER, and then click Restart.
    4. In the Restart Other Services dialog box, click Yes.
  7. Restart the Internet Information Service (IIS) on the server that is running Microsoft Dynamics CRM.
    1. Log on to the server that is running Microsoft Dynamics CRM.
    2. Click Start, click Run, type iisreset, and then click OK.
  8. Run the report again.
Modification Type:MinorLast Reviewed:8/9/2006
Keywords:kberrmsg kbtshoot kbMbsreports kbMBSMigrate kbprb KB909509 kbAudEndUser kbAudKnowledgeWorker
©2004 Microsoft Corporation. All rights reserved.