SSAS over HTTP through IIS

[Database Administrator]

hello everyone, I'm trying to manage this implementation:

- One server (2 node cluster) with AS 2005 installed
- One front-end web server with IIS installed

I configured IIS on port 8089 to run msmdpump.dll from AS bin
directory, I configured the environment following this tutorial
http://www.microsoft.com/technet/pro.../httpasws.mspx

And I managed to do everything, but when I try to connect using IE, I
get this error:

%1 is not a valid Win32 application

I also tried to connect using Excel, SQM manager and ProClarityWeb but
I get always the same error

SQL Console
"===================================

Cannot connect to http://sever:8089/olap/msmdpump.dll.

===================================

The connection either timed out or was lost.
(Microsoft.AnalysisServices.AdomdClient)

------------------------------
Program Location:

at Microsoft.AnalysisServices.AdomdClient.XmlaClient. EndRequest()
at
Microsoft.AnalysisServices.AdomdClient.XmlaClient. SendMessage(Boolean
endReceivalIfException, Boolean readSession, Boolean
readNamespaceCompatibility)
at
Microsoft.AnalysisServices.AdomdClient.XmlaClient. Discover(String
requestType, String requestNamespace, ListDictionary properties,
IDictionary restrictions, Boolean sendNamespacesCompatibility)
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.XmlaClientProvider.Microsoft.AnalysisServices .AdomdClient.AdomdConnection.IXmlaClientProviderEx .Discover(String
requestType, IDictionary restrictions, InlineErrorHandlingType
inlineErrorHandling, Boolean sendNamespaceCompatibility)
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.ReadDataSourceInfo()
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.ConnectToXMLA(Boolean
createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.Open()
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.ObjectExplorer.ValidateConnection(UIC onnectionInfo
ci, IServerType server)
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.Co nnector.ConnectionThreadUser()

===================================

The remote server returned an error: (500) Internal Server Error.
(System)

------------------------------
Program Location:

at System.Net.HttpWebRequest.GetResponse()
at
Microsoft.AnalysisServices.AdomdClient.HttpStream. GetResponseStream()
at
Microsoft.AnalysisServices.AdomdClient.HttpStream. GetResponseDataType()"

Proclarity WEB

The HTML element at line 1, column 6 (namespace) cannot appear under
(what ?!!?!?)

EXCEL
The HTML element at line 1, column 6 (namespace) cannot appear under

Same errors using Basic, Anonimous and Integrated logon

Thanks in advance for your help

[Database Administrator]

does the client has installed the SSAS 2005 drivers?
(download from the feature pack for SQL Server 2005)

from the IIS server, can you access the SSAS server correctly? (without
going through an HTTP connection)
if yes, doe the HTTP connection works fine locally on this server?
(use the ascmd utility to test both connections)

from what I understand, on the IIS server, you have copied the msmdpump.dll
file locally, then created a virtual server on the port 8089
you have changed the config file and setup the server name like:
MySSASClusterIP (or cluster dns name)

do you use NTLM authentication? or basic authentication?
if NTML, have you setup the kerberos authentication correctly?

have you define roles and add members to it in your SSAS databases? (if no,
try to create a role and add some users on it)

good luck!

"Polymar" wrote in message
news:1182769281.288290.196060@k79g2000hse.googlegr oups.com...
> hello everyone, I'm trying to manage this implementation:
>
> - One server (2 node cluster) with AS 2005 installed
> - One front-end web server with IIS installed
>
> I configured IIS on port 8089 to run msmdpump.dll from AS bin
> directory, I configured the environment following this tutorial
> http://www.microsoft.com/technet/pro.../httpasws.mspx
>
> And I managed to do everything, but when I try to connect using IE, I
> get this error:
>
> %1 is not a valid Win32 application
>
> I also tried to connect using Excel, SQM manager and ProClarityWeb but
> I get always the same error
>
> SQL Console
> "===================================
>
> Cannot connect to http://sever:8089/olap/msmdpump.dll.
>
> ===================================
>
> The connection either timed out or was lost.
> (Microsoft.AnalysisServices.AdomdClient)
>
> ------------------------------
> Program Location:
>
> at Microsoft.AnalysisServices.AdomdClient.XmlaClient. EndRequest()
> at
> Microsoft.AnalysisServices.AdomdClient.XmlaClient. SendMessage(Boolean
> endReceivalIfException, Boolean readSession, Boolean
> readNamespaceCompatibility)
> at
> Microsoft.AnalysisServices.AdomdClient.XmlaClient. Discover(String
> requestType, String requestNamespace, ListDictionary properties,
> IDictionary restrictions, Boolean sendNamespacesCompatibility)
> at
> Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.XmlaClientProvider.Microsoft.AnalysisServices .AdomdClient.AdomdConnection.IXmlaClientProviderEx .Discover(String
> requestType, IDictionary restrictions, InlineErrorHandlingType
> inlineErrorHandling, Boolean sendNamespaceCompatibility)
> at
> Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.ReadDataSourceInfo()
> at
> Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.ConnectToXMLA(Boolean
> createSession, Boolean isHTTP)
> at Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.Open()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.ObjectExplorer.ValidateConnection(UIC onnectionInfo
> ci, IServerType server)
> at
> Microsoft.SqlServer.Management.UI.ConnectionDlg.Co nnector.ConnectionThreadUser()
>
> ===================================
>
> The remote server returned an error: (500) Internal Server Error.
> (System)
>
> ------------------------------
> Program Location:
>
> at System.Net.HttpWebRequest.GetResponse()
> at
> Microsoft.AnalysisServices.AdomdClient.HttpStream. GetResponseStream()
> at
> Microsoft.AnalysisServices.AdomdClient.HttpStream. GetResponseDataType()"
>
> Proclarity WEB
>
> The HTML element at line 1, column 6 (namespace) cannot appear under
> (what ?!!?!?)
>
> EXCEL
> The HTML element at line 1, column 6 (namespace) cannot appear under
>
> Same errors using Basic, Anonimous and Integrated logon
>
> Thanks in advance for your help
>

[crocosco]

Hi,

have you found any solution? (I'm having the same problem )