Hi

In all my documentation I find that OLAP ( Analysis Server / SQL server 2000 ) will only run on Win 2000 or NT sp5. Why not on XP

GKramer

It works on XP too!


Peace,
Andrej


"GKramer" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi,

my experience:
no problems with xp professional (for sql you need the
personal-edition)

analysis with xp home doesn't work.


Matthias

Yes and SQL Developer Edition works too. That is on XP Proffesional.



"Matthias Gyoerfi" <gyoerfi (AT) gmx (DOT) de> wrote

The web component for XP is actually a lot better...

Andrej Hudoklin <andrej.hudoklin (AT) add (DOT) si> wrote

Andrej

I have a local installation of SQLserver 2000 / Analysis on my computer and can connect to any SQL server in our lan and build a cube but when I try to connect to my own local environment it promt that it is too busy or not running ( It is running and not busy !! )

Can you tell me what's the reason for this
And If you are an expert please let me know where it stores the data ( for building a cube ) exactly? Because in all documentation I have this is NOT mentioned

Regards, and thanx in advance

GKramer

Hi,

tell me what version of XP and SQL Server you have? Which service pack have
you installed for XP and Analysis Server?

Then:
first check under what account is MSSQLServerOLAPService started - put your
account (administrator)
then check if your account is under OLAP Administrator group


AS stores aggregates and you can find it under AS installation folder
most common: ..\Program Files\Microsoft Analysis Services\Data


Regards,
Andrej



"GKramer" <anonymous (AT) discussions (DOT) microsoft.com> wrote

try to connect to my own local environment it promt that it is too busy or
not running ( It is running and not busy !! ).
mentioned.