Setting up SQL Server & Analysis Services

[Rob999]

Hi everyone. I got my new computer at home (with Windows XP Home Edition) and have installed SQL Server 2000 Enterprise Edition, and Analysis Servics. It's been a couple years since I had to do this and now I'm having a problem.

When I open up Analysis Services I can see the name of my Analysis Server 'COMPUTER1', but when I go to connect to this server - my only server - I get the following message:

Unable to read the Server Registry, or you are not a member of the OLAP Administrators Group.

I'm using Windows Authentication on my installation - though I don't have a log in. I'm able to run all kinds of code and manipulate all the objects in SQL Server, so I'm being recognized as the dbo and sa (I'm the only registered login/user). The only OLAP Administrators Group I can find is actually a LOGIN, not a group, so I can't add myself to it.

Do I need to remove Windows XP Home and try and install Windows 2000 Pro?

If anyone has any ideas, I'd sure like to hear them...

Thanks!!!

 

[MDXer]

Probably. You need access to the Roles so you can add your login to the olap admin group, which I don't believe you can do under XP Home.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[johnherman]

From the earliest days, Analysis Services (formerly OLAP Services) would only run on the server version of the OS; NT Server way back, then W2K server, and now with XP. It will not run on workstation or anything "lower".

Sometimes the grass is greener on the other side because there is more manure there - original.