I am trying to access analysis services from within SQL server to query an
olap data source, but get an 'Access denied' error. When I run the query in
the SQL server sitting on the same box as the olap database, I get the
error, but if I run the query in the SQL server sitting on my desktop,
against the same server, I don't get the error message. My initial though
was that this might be some sort of account delegation issue, but want to
make sure before I start messing around with active directory and kerberos.
Does anyone know what's causing this error and how to fix it?

Example query:
select *
FROM OPENROWSET
(
'MSOLAP.2',
'DATASOURCE=cubeserver;CATALOG="MyCubeDB"',
'SELECT { [User Count]} ON COLUMNS, NON EMPTY {[InstallDate].[Daily
Date].Members} ON ROWS FROM [Users]')

The error message:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSOLAP.2' reported an error. Access denied.
OLE DB error trace [OLE/DB Provider 'MSOLAP.2' IUnknown::QueryInterface
returned 0x80070005: Access denied.].

Hi,

Have you installed SP3 on the server and PTSLite.exe on
the client?

Ta
Paul

Yes, the server is on SP3 for both Analysis Services and SQL Server. The
server is the same machine as the client, so I wouldn't think I would need
to install PTSLite -- that's the OLEDB driver, correct?

--RJ
<anonymous (AT) discussions (DOT) microsoft.com> wrote

Maybe your SQL server has running under windows account what do not have
rights to access AS cube?

"RJ Smith" <rjs (AT) 180solutions (DOT) com> ñîîáùèë/ñîîáùèëà â íîâîñòÿõ ñëåäóþùåå:
news:ONyc2ElIEHA.3536 (AT) TK2MSFTNGP09 (DOT) phx.gbl...