我使用MSOLAP提供程序连接分析服务器。因此,我做了下面的连接字符串,并尝试建立从应用程序/web服务器到SSAS服务器的连接
连接字符串
Provider=MSOLAP.2; Data Source=172.16.53.3; Initial Catalog=Myyres;
使用的代码片段
AdomdConnection objAdomdConn = new AdomdConnection();
objAdomdConn.ConnectionString = a_strConnSting;
objAdomdConn.Open();
错误发生"无法建立连接。确保服务器正在运行。"
堆栈跟踪输出
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection+IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at StackOverflow.AdoMD.button1_Click(Object sender, RoutedEventArgs e)
当我在SSAS服务器上运行时,相同的代码正在工作。我只有在从appweb服务器调用到SSAS服务器时才会出错
期望的连接字符串
connectionString = "数据源=ServeName;集成安全=SSPI;初始目录=DBName;";
要连接Windows身份验证,请在连接字符串
中添加"Integrated Security=SSPI;"要连接SQL身份验证,添加"用户ID=userID;