How to test connectivity to an analysis server over HTTP and over HTTPS in Commerce Server 2002 (889575)


The information in this article applies to:

  • Microsoft Commerce Server 2002

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 "Accessing the analysis server over HTTPS" section of the Commerce Server 2002 documentation.

To view the "Accessing the analysis server over HTTPS" 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 Edition dialog box, click the Contents tab.

    The placeholder Edition is the placeholder for the Commerce Server edition that you are running.
  3. Expand Commerce Server 2002 Edition, 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 "Accessing the analysis server over HTTPS" 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. 
<HTML>
<BODY>
  <object classid=clsid:0002E552-0000-0000-C000-000000000046 id="PTable" 
Width="200" Height="200"></object>
</BODY>
<SCRIPT language=vbscript>

  Function Window_OnLoad()
  PTable.AutoFit = false

  PTable.ConnectionString = "Provider=MSOLAP.2;Integrated Security=SSPI;Initial 
Catalog=<xxx>;Data Source=http://<xxx>;"

  PTable.DataMember = "<xxx>"

  End Function

</SCRIPT>
</HTML>
Note You must modify the previous code example to replace the "<xxx>" 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.

REFERENCES

For additional information about how to access analysis server over HTTPS, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn.microsoft.com/library/en-us/csvr2002/htm/cs_se_secure_dw_npcs.asp


Modification Type:MajorLast Reviewed:7/19/2005
Keywords:kbconnectivity kbcode kbhowto kbinfo KB889575 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.