Unable to access AS2k from Win 2k m/c URGENT!!!!!!

From: Ri*** (mithun_vesit_at_yahoo.com)
Date: 10/11/04 

Date: Sun, 10 Oct 2004 18:55:22 -0700

Problem Definition

My machine details: Win XP m/c with .NET framework 1.0,
MSXML 4.0 parser, XML For Analysis 1.1, ADOMD.NET (8.0).

SQL Server 2000 and Analysis Server 2000 are both hosted
on the same but not on my m/c.

Currently my web client, web services are both hosted on
my machine. The client calls the web service which then
calls both SQL Server and Analysis Server for fetching
data.

The config file of my client app has the following
settings:
<add key="DB_CONNECTION_STRING" value="Data
Source=servername;Provider=MSOLAP;initial
catalog=Reporting;ConnectTo=8.0"></add>
<add key="WebServiceURL"
value="http://localhost/enterprisewebservice/pipelineservic
e.asmx" />

<identity impersonate="false" />

Both Anonymous access and WINdows Authentication options
are enabled in IIS for this web site.

My web service has the following setting in config file:

<add key="DB_CONNECTION_STRING" value="Data
Source=servername;Provider=MSOLAP;initial
catalog=Reporting;ConnectTo=8.0"></add>

<identity impersonate="true"/>. This tag was made true
after browsing sites and newsgroups on ADOMD.net.

With the above settings, everything works fine on my m/c
(Dev m/c) . The web service is able to make calls to AS
through ADOMD.NET and fetch data.

Now I have hosted my application on a QA test server. This
is Win 2k m/c with Service Pack 4, .NET framework 1.0,
ADOMD.NET 8.0, MSXML parser 4.0, XML For Analysis 1.1.
The web service in this case just doesn't work if
impersonation is true. It shows "Server not available" IN
the even log I have " aspnet_wp.exe stopped unexpectedly"

If I remove this tag, the above error disappears. But
still the web service is unable to fetch data from AS. It
fails while opening a connection. Had added some trace
code lately.
The code snippet is :
   <WebMethod(Description:="Returns cellset"), _
        SoapHeader("headerObj")> _
   Public Function ReturnCellSet(ByVal queryString As
String) As String
        'Check the SoapHeader
        Dim result As String
        Dim adomdConnection As AdomdConnection
        Dim reader As System.Xml.XmlReader
        Try
               adomdConnection = New AdomdConnection
(ConfigurationSettings.AppSettings("DB_CONNECTION_STRING"))
                       adomdConnection.Open()
                       Dim adomdCommand As New AdomdCommand
(queryString, adomdConnection)
            reader = adomdCommand.ExecuteXmlReader()
                        Dim doc As XmlDocument = New
XmlDocument()
            doc.LoadXml(reader.ReadOuterXml())
                       doc.Save(Server.MapPath(".")
& "\Results.xml")
                        result = doc.OuterXml()
        Catch con As AdomdConnectionException
                   Catch e As AdomdErrorResponseException
                   Catch f As AdomdConnectionException
                    Catch exp As Exception
                    Finally
                       reader.Close()
            adomdConnection.Close()
        End Try
        Return result
    End Function

I feel this problem is related to 2 things:
1. The configuration of Win2k m/c. Is it missing
something that I am not aware of?
2. The authenctication mechanism that is in place in
this scenario. Something related to impersonation? Does MS
Analysis server need more credentials than specified in my
connection string? How do I provide that? In SQL server,
we have mixed mode, so we can provide the username/pwd for
a connection? IS there an equivalent here also??
3. One thing I read at places was "ADOMD.NET not
allowing direct connection"Don't know what that means.
Also, at places, using XMLA http value was suggested to be
used in the connection string.

I need help on this issue urgently..

Thanks in advance
Ri***