Microsoft KB Archive/923502

= Error message when you try to upload an Excel 2007 workbook to an Excel Web Access Web Part in Windows SharePoint Services 3.0: &quot;The request failed with HTTP status 401: Unauthorized.&quot; =

Article ID: 923502

Article Last Modified on 5/14/2007

-

APPLIES TO


 * Microsoft Office SharePoint Server 2007
 * Microsoft Windows SharePoint Services 3.0
 * Microsoft Office Excel 2007

-



SYMPTOMS
You add a Microsoft Office Excel Web Access Web Part to a Web page in a Microsoft Windows SharePoint Services 3.0 site. Then, you try to upload a Microsoft Office Excel 2007 workbook to the Excel Web Access Web Part. However, you receive the following error message:

The request failed with HTTP status 401: Unauthorized.



CAUSE
This issue occurs if you configure the Shared Services Provider (SSP) Web application that hosts Excel Calculation Services to use Basic authentication. Excel Calculation Services does not support Basic authentication. By default, Windows SharePoint Services 3.0 uses Integrated Windows authentication.



RESOLUTION
Configure the SSP Web application that hosts Excel Calculation Services to use Integrated Windows authentication. To do this, follow these steps:
 * 1) Click Start, point to All Programs, point to Microsoft Office Server, and then click SharePoint 3.0 Central Administration.
 * 2) Click the Application Management tab. Then, click Authentication providers under Application Security on the Application Management page.
 * 3) On the Authentication Providers page, click the down arrow in the Web Application box, click Change Web Application, and then click the Web application that you want to configure.
 * 4) Under Membership Provider Name, click Windows. Then, in the IIS Authentication Settings area of the Edit Authentication page, click to clear the Basic authentication (password is sent in clear text) check box.
 * 5) Click to select the Integrated Windows authentication check box. Then, click either Negotiate (Kerberos) or NTLM. Your choice depends on the security configuration that you want.
 * 6) Click Save.



MORE INFORMATION
For more information about Excel Services, visit the following Microsoft Web site:

http://msdn2.microsoft.com/en-us/library/ms546696.aspx

Additional query words: wss wssv3 moss moss2007 ecs xl2007 Excel2007

Keywords: kbexpertisebeginner kberrmsg kbprb kbexpertiseinter kbtshoot KB923502

-

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

© Microsoft Corporation. All rights reserved.