Microsoft KB Archive/325617

= PRB: Access Denied When You Access OLAP Server Over HTTP with Office Web Components =

Article ID: 325617

Article Last Modified on 8/27/2002

-

APPLIES TO


 * Microsoft Office Web Components

-



This article was previously published under Q325617



SYMPTOMS
You can use the Office XP Web Components to access online analytical processing (OLAP) data sources using HTTP. If the Web server that processes the OLAP request cannot authenticate the user, the Web Components respond with the following error message:

The query could not be processed:


 * Access Denied

NOTE: The error message can occur with Basic Authentication or NTLM.



CAUSE
The Microsoft OLAP Provider communicates with the OLAP server through an Active Server Pages (ASP) page (msolap.asp) on the Web server. Information is sent to the ASP page using a POST request, and is then forwarded to the OLAP server. Likewise, OLAP returns information to the ASP page, which is then forwarded to the client. If the client computer does not have access to msolap.asp, the Web server returns Error 401 that is listed in the &quot;Symptoms&quot; section. The Office Web Components display the error message instead of prompting for authentication.



RESOLUTION
If the client cannot be authenticated on the Web server, the only way around the error message is to supply the authentication information in the connection string for the Web Components.



STATUS
This behavior is by design.



Steps to Reproduce the Behavior
  In Notepad, paste the following HTML:    sub button1_onclick PivotTable1.ConnectionString = &quot;Provider=MSOLAP.2;Integrated Security=SSPI;&quot; + _ &quot;Data Source=http://;Initial Catalog=FoodMart 2000&quot; PivotTable1.DataMember = &quot;Sales&quot; end sub NOTE: Where  is the name of an OLAP server that is accessible with HTTP.

 Save the file as follows: C:\PivotTest.htm. Verify that the Web server requires only Basic Authentication to access the OLAP server.</li> Start Internet Explorer, and then locate C:\PivotTest.htm. A page is displayed that contains a PivotTable and a button. When you click the button, the error that is listed in the &quot;Symptoms&quot; section appears in the PivotTable.</li>  To work around the problem, supply the user name and password for a valid account on the connection string: PivotTable1.ConnectionString = &quot;Provider=MSOLAP.2;UID=TestUser;Password=Test;&quot; + _ &quot;Data Source=http://<OLAP server>;Initial Catalog=FoodMart 2000&quot; NOTE: In this code, change TestUser and Test to reflect the valid user name and password, respectively. </li></ol>

<div class="references_section">