Microsoft KB Archive/889575

= How to test connectivity to an analysis server over HTTP and over HTTPS in Commerce Server 2002 =

Article ID: 889575

Article Last Modified on 3/13/2007

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition

-





INTRODUCTION
This article describes how to test connectivity to an analysis server over HTTP and over HTTPS in Microsoft Commerce Server 2002. You can test both configuration and connectivity. You can do this test after you follow the steps in the &quot;Accessing the analysis server over HTTPS&quot; section of the Commerce Server 2002 documentation.

To view the &quot;Accessing the analysis server over HTTPS&quot; section of the Commerce Server 2002 documentation, follow these steps:
 * 1) Click Start, point to All Programs, point to Microsoft Commerce Server 2002, and then click Commerce Server Documentation.
 * 2) In the Microsoft Commerce Server 2002   dialog box, click the Contents tab.

The placeholder  is the placeholder for the Commerce Server edition that you are running.
 * 1) Expand Commerce Server 2002  , expand Securing Your Site, expand Securing Your Databases, expand Securing the Data Warehouse, and then click Accessing the Analysis Server Over HTTPS.



MORE INFORMATION
After you follow the steps in the &quot;Accessing the analysis server over HTTPS&quot; section of the Commerce Server 2002 documentation, you can use the following HTML document as an example to test your configuration. Additionally, you can use the following HTML document to verify connectivity to your Online Analytical Processing (OLAP) server. The following HTML document can help you troubleshoot OLAP over HTTP issues.

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.     

Function Window_OnLoad PTable.AutoFit = false

PTable.ConnectionString = &quot;Provider=MSOLAP.2;Integrated Security=SSPI;Initial Catalog= ;Data Source=http:// ;&quot;

PTable.DataMember = &quot; &quot;

End Function

  Note You must modify the previous code example to replace the &quot; &quot; values with the correct values for your Commerce Server 2002 installation.

You can use the previous code example whether you configure your connection over HTTP or over HTTPS. When you connect to the OLAP server successfully, click Field List to view the data that is available to add to the blank report.

