Hello,
I'm fighting for 2 weeks on SSAS over http.
I've done the config as metionned in many furums but always the same result ; http 500.
My config :
Win 7 , SQL SERVER 2008 R2 , IIS 7 , and TFS (Team fondation server)
The result is the same via SQL studio manager , direct HTML and EXCEL ?
here is the result :
Impossible de se connecter à
http://localhost/olap/msmdpump.dll.
------------------------------
INFORMATIONS SUPPLÉMENTAIRES :
La connexion a expiré ou elle a été perdue. (Microsoft.AnalysisServices.AdomdClient)
------------------------------
Le serveur distant a retourné une erreur : (500) Erreur interne du serveur. (System)
the detailled msg :
===================================
Impossible de se connecter à
http://localhost/olap/msmdpump.dll.
===================================
La connexion a expiré ou elle a été perdue. (Microsoft.AnalysisServices.AdomdClient)
------------------------------
Emplacement du programme :
à Microsoft.AnalysisServices.AdomdClient.XmlaClient.EndRequest()
à Microsoft.AnalysisServices.AdomdClient.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility)
à Microsoft.AnalysisServices.AdomdClient.XmlaClient.Discover(String requestType, String requestNamespace, ListDictionary properties, IDictionary restrictions, Boolean sendNamespacesCompatibility)
à Microsoft.AnalysisServices.AdomdClient.XmlaClient.Discover(String requestType, ListDictionary properties, IDictionary restrictions, Boolean sendNamespacesCompatibility)
à Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String requestType, IDictionary restrictions, InlineErrorHandlingType inlineErrorHandling,
Boolean sendNamespaceCompatibility)
à Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ReadDataSourceInfo()
à Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
à Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
à Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server)
à Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
===================================
Le serveur distant a retourné une erreur : (500) Erreur interne du serveur. (System)
------------------------------
Emplacement du programme :
à System.Net.HttpWebRequest.GetResponse()
à Microsoft.AnalysisServices.AdomdClient.HttpStream.GetResponseStream()
à Microsoft.AnalysisServices.AdomdClient.HttpStream.GetResponseDataType()
I have got the same config on another pc and it' working ? (but without TFS and with SQL 2008 instead of R2)
an Idea ?
Best regards
Thanks in advance for you replay.
Christophe
SSAS over HTTP via msmdpump.dll : http 500 error
