Error message when you try to run a report in Microsoft Dynamics CRM 3.0: "The request failed with HTTP status 401: Unauthorized" (921546)



The information in this article applies to:

  • Microsoft CRM 3.0

SYMPTOMS

When you try to run a report in Microsoft Dynamics CRM 3.0, you receive the following error message:
The request failed with HTTP status 401: Unauthorized.

CAUSE

This problem occurs because the security account for the CRMAppPool application pool does not have the Publisher for Microsoft Dynamics CRM role in Report Manager.

RESOLUTION

To resolve this problem, follow these steps:
  1. Find the user. To do this, follow these steps:
    1. On the Microsoft Dynamics CRM server, click Start, click Run, type compmgmt.msc /s, and then click OK to open Computer Management.
    2. Expand Services and Applications, expand Internet Information Services (IIS) Manager, expand Application Pools, right-click CRMAppPool, and then click Properties.
    3. In the CRMAppPool Properties dialog box, note the value in the Predefined box on the Identity tab.

      Note The value is the user who you want to find.
  2. Set the Publisher for Microsoft Dynamics CRM role to the user. To do this, follow these steps:
    1. On the Microsoft Dynamics CRM server, type the following address in the Address bar in Microsoft Internet Explorer, and then click Go to open Reporting Services Report Manager:

      http://SRSServer/Reports

      Note SRSServer is a placeholder that represents an actual name of a Microsoft SQL Server Reporting Services server.
    2. Click the Microsoft Dynamics CRM company name.

      Note The Microsoft Dynamics CRM company name resembles the following:

      CRM_Company_Name_MSCRM

    3. On the Properties tab, click Security.
    4. Check to see whether the user who you found in step 1 is listed.

      Note If the user is not listed, click New Role Assignment.
    5. In the Group or user name box, type the name of the user who you noted in step 1c.

      Note If the name of the user is "Network Service," type the following name in the Group or user name box:

      NT Authority\Network Service

    6. Click to select the Publisher for Microsoft CRM check box, and then click OK.

Modification Type:MajorLast Reviewed:6/23/2006
Keywords:kbtshoot kbMbsreports kberrmsg kbMBSMigrate kbprb KB921546 kbAudEndUser kbAudKnowledgeWorker