Microsoft KB Archive/916168

= Error message when you try to access Reports in Microsoft CRM 3.0: &quot;Server Error in '/' Application&quot; =

Article ID: 916168

Article Last Modified on 6/12/2006

-

APPLIES TO


 * Microsoft Dynamics CRM 3.0

-





SYMPTOMS
When you try to access Reports in Microsoft Dynamics CRM 3.0, you receive the following error message:

Error An error has occurred. For more information, contact your system administrator.

If the DevErrors value is set to &quot;On&quot; in the Web.config file, you receive the following error message:

With Dev Errors: Server Error in '/' Application.

The request failed with HTTP status 401: Unauthorized.



CAUSE
This problem occurs because the authentication method that is used for the Microsoft SQL Server Reporting Services Web site does not request the Kerberos version 5 protocol.



RESOLUTION
To resolve this problem, follow these steps:  Perform the additional setup tasks that are required for Reporting Services. To obtain the instructions for these additional setup tasks, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=51bf9f20-bd00-4759-8378-b38eefda7b99&DisplayLang=en

 Set the correct NTAuthenticationProviders values in the Microsoft Internet Information Services (IIS) metabase for the Reporting Services Web site. To do this, follow these steps:  Set the correct NTAuthenticationProviders values at the root level. To obtain the instructions for setting the correct NTAuthenticationProviders values, click the following article number to view the article in the Microsoft Knowledge Base:

215383 How to configure IIS to support both the Kerberos protocol and the NTLM protocol for network authentication

 Determine the Web site ID for the Reporting Services Web site. To do this, follow these steps:  Start IIS Manager. Click Web Sites, and then note the ID of the Web site that is hosted by the CRM server on which Reporting Services is installed.</li></ol> </li> Open a Command Prompt window, and then type the following:



</li>  Use the Identifier value to set the NTAuthenticationProviders value for the Web site level.

In the following code example, SRS_WEB_SITE_ID represents the Web site ID of the Reporting Services Web site. cscript adsutil.vbs set w3svc/ <SRS_WEB_SITE_ID> /NTAuthenticationProviders &quot;Negotiate,NTLM&quot; cscript adsutil.vbs set w3svc/NTAuthenticationProviders &quot;Negotiate,NTLM&quot; </li></ol> </li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_section">

Steps to reproduce the problem
<ol> Start IIS Manager.</li> Click Web Sites, and then note the ID of the Web site that is hosted by the CRM server on which Reporting Services is installed.</li> Open a Command Prompt window, and then type the following:

C:\Inetpub\AdminScripts

</li> At the command prompt, type the following:

cscript adsutil.vbs set w3svc\ \ntauthenticationproviders &quot;NTLM&quot;

Note represents the Web site ID that you noted in step 2.</li> Access Reports in Microsoft CRM.</li></ol>

<div class="references_section">