Hello,

I have a cube on an Analysis Services 2000 database that I am trying to
get my users to hook up to via Excel 2003. When the users try to
access the cube, the get an error message back saying that "either the
OLAP database has been changed or you don't have permission to access
the cube"

I can connect on my machine, and if a user logs on to my machine, they
can connect also, so it does not appear to be permissions (to be sure I
added Everyone in the database role)
The cube is processed and available. I can connect via the msas client
as well as excel.

I tried the following:
Confirmed that the msolap80.dll version was the same as mine
(8.0.760.0)
Installed PTS (tried both full & Lite as taken from the SP3a download)
Tried unregistering & re-registering the msolap80.dll
Verified that the connection string was using msolap.2

After all of the above, my problem still exists.
What else should I be looking at?

Thanks,
Justin

Are you part of the olap administrator user group.

If not you need to set database roles in AS that would alow you to look at
data.


"jbram" <jbram117 (AT) yahoo (DOT) com> wrote

If you can confirm that this issue is related to a machine rather than a
specific user, it could be a problem with the registration of the msolap
provider.

I have seen instances where the 7.0 and 8.0 providers get cross linked.
Can I suggest that you try using regsvr32 to unregister msolap.dll and
msolap80.dll and then register them. I would try running the following
commands in the following order.

regsvr32 -u msolap80.dll
regsvr32 -u msolap.dll
regsvr32 msolap.dll
regsvr32 msolap80.dll

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1131383120.888051.323030 (AT) g49g2000cwa (DOT) googlegroups.com>,
jbram117 (AT) yahoo (DOT) com says...

Not a permission issue. My users all had access to the cube in
question. They could access the cube from another machine with their
login.
Once I did a Detect and Repair from Excel, the user could access the
cube.

Thanks for the suggestions.
Justin