Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sponguru_dba
Yak Posting Veteran
93 Posts |
 Posted - 2009-08-27 : 12:08:26
|
| Hi allI h've T-SQL Procedure with MDX Query running from OLTP and feching Data from OLAP cube.some time it is getting fail and giving an errorOLE DB provider "MSOLAP" for linked server "My_OLAP_Connection" returned message "Errors in the OLE DB provider. A valid instance named 'My_instance'cannot be found on the 'MyServer' server.".Msg 77777, Level 16, State 1, Procedure myprocedure, Line 1015Error has occured while Executing the SP myprocedureCannot initialize the data source object of OLE DB provider"MSOLAP" for linked server "My_OLAP_Connection".Please help regarding this issueSNIVAS |
|
|
|
|
|
Msg 77777, Level 16, State 1, Procedure myprocedur