无法初始化OLE DB提供程序的数据源对象“MSOLAP”。对于链接服务器“SSASCUBE1”。 [英] Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "SSASCUBE1".

问题描述

嗨 

我们正在尝试从使用链接服务器到SSAS多维数据集的Web应用程序调用存储过程来提取数据..

多年来工作正常..

但是从2周开始它才开始失败，只是从那个网络应用程序投掷以下错误：

无法初始化OLE DB提供程序的数据源对象" MSOLAP"对于链接服务器"SSASCUBE1"。

解决方案

您需要添加服务器登录。

   EXEC   sys  。  sp_configure N  'remote query timeout（s）' ，  N  '6000'  
 GO 
   RECONFIGURE     WITH   OVERRIDE   

ss

参考以下链接

HTTPS：//dba.stackexchange。 com / questions / 82379 / linked-server-from-sql-server-to-ssas-not-working-what-is-missing

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/94dc4317-1848-4fd7 -bb90-7ddd48564509 / can-initialize-the-data-source-object-of-ole-db-provider-msolap-for-linked-server-null？forum = sqlanalysisservices

Hi 

We are trying to call a stored procedure from a web application that uses linked server to SSAS cube to pull the data ..

It was working fine for many years..

But since 2 weeks it started failing only from that web application and throwing the below error :

Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "SSASCUBE1".

解决方案

you nee add server login.

EXEC sys.sp_configure N'remote query timeout (s)', N'6000'
GO
RECONFIGURE WITH OVERRIDE

ss

refer following link

https://dba.stackexchange.com/questions/82379/linked-server-from-sql-server-to-ssas-not-working-what-is-missing

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/94dc4317-1848-4fd7-bb90-7ddd48564509/cannot-initialize-the-data-source-object-of-ole-db-provider-msolap-for-linked-server-null?forum=sqlanalysisservices

这篇关于无法初始化OLE DB提供程序的数据源对象“MSOLAP”。对于链接服务器“SSASCUBE1”。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！