Hello !

We are using a Windows 2003 Server and Analysis Services 2000 SP3.

The clients works with IE 6.0 HTML-Pages with
Pivot-Table-Active-X-control.
VB-Script makes a Connection to the OLAP-Cubes.

Function GetOLAPCn
GetOLAPCn = "provider=msolap.2;data source=lvolap;initial
catalog =OLAP;Integrated Security=SSPI;"
End Function

Yesterday we rebootet the Server and the client cannot get data since
then.

The facts:
-If I put the User to the administrators on the server it works (but
this is not really a solution)
-the roles of the cubes are not the probem. I tried to access the
cubes via Excel - the same problem: I cant even cant see the databases
(OLAP, Foodmart)
-in the same way the user habe access to SQL-Server-Tables. this works
fine.

The error message
0x80004005 Database not available. Connection could not be opened.
Databases cant be loaded.

Do you have any idea. Do I have to change any security settings on
Windows 2003 Server ?

Many thanks !
aaaPaul

80004005 is access is denied.
Check to see if some kind of ACL was applied to your Analysis Services
installation folder or below.

The fact that adding the user to the Administrators group fixes the problem
would seem to indicate a similar thing.

Since it is a reboot which caused this, might you have done something which
is only effective after a reboot, such as change the domain, etc.
--
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.

"aaapaul" <lvpaul (AT) gmx (DOT) net> wrote

Problem is solved.

I reinstalled Analysis Services and AS-SP3a on the server and now it works.

Crazy thing.

Thanks.
Paul