Principale utente con più risposte
I run openquery() from a client application(sql 2005) to query SSAS data(sql 2005) through a linked server(sql 2005), but I get the following error:
OLE DB provider "MSOLAP" for linked server "LINKEDMINING" returned message "An error was encountered in the transport layer.".
OLE DB provider "MSOLAP" for linked server "LINKEDMINING" returned message "The peer prematurely closed the connection.".
Msg 7303, Level 16, State 1, Procedure gettpdt, Line 3
Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "LINKEDMINING".
And, I am sure that I have made the MSOLAP provider Allow inprocess.
What can i do for this. Please advise.
Tutte le risposte
Although the post is very old, I am a just posting a link so that future users can get some help. I hope this might resolve the problem for some users.
My Programming Site
- Proposto come risposta Aravind Kamath mercoledì 21 marzo 2012 15:41
http://blog.programmingsolution.net/ssas-2008/retrieve-ssas-cube-data-in-tabular-format-from-stored-procedure-using-linked-server/ link helped me to resolve the issue.
I have same problem. Can you help me?
I can create linked server only by command line with
but when I try to grant permissions to the user DOMAIN\USER these errors appear:
OBS: I’ll transcribe the content of message box SSMS
The linked Server has been update but failed a connection test. Do you want to edit the linked server properties?
-> An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
-> The OLE DB provider “MSOLAP” for linked server “OLAPAS” reported an error. The provider did not give any information about the error.
Cannot set the initialization properties for OLE DB provider “MSOLAP” for linked server “OLAPAS”. (Microsoft SQL Server, Error: 7399)