Hello all,

I need to a very simple MDX query from a stored procedure, but am
having a hard time with the connection.

I get the below:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSOLAP' reported an error.
[OLE/DB provider returned message: Cannot initialize Microsoft® SQL
Server Analysis Services.]
OLE DB error trace [OLE/DB Provider 'MSOLAP' IDBInitialize::Initialize
returned 0x80004005: ].

I was also getting an Access Denied error before, that seemed to
disappear after I followed the advice of some post to check the "allow
in process" under provider options.

Can anyone point me to some information on how I need to set up the
linked server? It seems like I've tried every permutation of security
but am having no luck. On my own local sql server, with a local
Analysis Server, I can run an OpenQUery using a linked server to an
Analysis Server with no problem.

Or is there anyway way I could do some kind of trace on the Analysis
Server so I could see what my OpenQuery is trying to login as?

thanks,
Sylvia

The AS Ops Guide has some samples using OpenQuery via linked server, but it
doesn't address this specific error.
http://www.microsoft.com/technet/pro.../anservog.mspx

You might try using the AuditEvents registry setting, see:
http://msdn.microsoft.com/library/de...egsettings.asp
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Sylvia" <Puget4753 (AT) yahoo (DOT) com> wrote

Hello all,

I need to a very simple MDX query from a stored procedure, but am
having a hard time with the connection.

I get the below:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSOLAP' reported an error.
[OLE/DB provider returned message: Cannot initialize Microsoft® SQL
Server Analysis Services.]
OLE DB error trace [OLE/DB Provider 'MSOLAP' IDBInitialize::Initialize
returned 0x80004005: ].

I was also getting an Access Denied error before, that seemed to
disappear after I followed the advice of some post to check the "allow
in process" under provider options.

Can anyone point me to some information on how I need to set up the
linked server? It seems like I've tried every permutation of security
but am having no luck. On my own local sql server, with a local
Analysis Server, I can run an OpenQUery using a linked server to an
Analysis Server with no problem.

Or is there anyway way I could do some kind of trace on the Analysis
Server so I could see what my OpenQuery is trying to login as?

thanks,
Sylvia