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:
- Click Start, point to All
Programs, point to Microsoft Commerce Server 2002,
and then click Commerce Server Documentation.
- 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. - 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.
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>
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.
For additional information about how to access analysis
server over HTTPS, visit the following Microsoft Developer Network (MSDN) Web
site: