I am having trouble installing sql server analys services (olap) on windows
xp machine.

Here are the installation steps.

1. insert sql server 2000 cd in the cd drive.
2. I get html page listing titled 'msdn subscriptions'.
3. select Microsoft® SQL Server™ 2000, Enterprise Edition
4. Windows explorer opens with following path: D:\ENGLISH\SQL2000\ENT
5. select msolap folder
6. select install folder
7. run setup program.
8. Install the service pack sp3a for analysis services which as 3 exe files:
sql2kasp3, sql2kdesksp3, and sql2ksp3.

After I install analysis services, I am able to build the cube. On the cube,
I select process, and then try to 'Browse Data'. I get an error message:

"Unable to browse the cube 'State' Unspecified error.

I have installed/un installed analysis service several time even with latest
service pack but I keep getting the above error.

Please help and thank you in advance..

Hi Trisha,

Look to see if the MDX Sample app can query the cube. Can you see the
Foodmart Sales cube from the browser?

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