Does anyone know if Analysis Services will work with Windows XP Home Edition. I installed SQL Server Developer Edition along with Analysis Services and English Query. When I tried to connect to the server in Analysis Services, I keep getting something about the registry connection or that I am not a member of the OLAP Administrators group. Since XP Home Edition has something of a watered down version of group and user management, I'm not sure if this can be done. Should this be done in the Security container within the default instance of SQL Server 2000 as a new login? If so, can anyone provide details? Please help.

Thanks,
John Nagy
wizardbeast (AT) worldnet (DOT) att.net

I have it running OK on XP, check out this link

http://msdn.microsoft.com/library/de...urity_841l.asp

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
"John Nagy" <wizardbeast (AT) worldnet (DOT) att.net> wrote

Services and English Query. When I tried to connect to the server in
Analysis Services, I keep getting something about the registry connection or
that I am not a member of the OLAP Administrators group. Since XP Home
Edition has something of a watered down version of group and user
management, I'm not sure if this can be done. Should this be done in the
Security container within the default instance of SQL Server 2000 as a new
login? If so, can anyone provide details? Please help.

You probably have already checked, but in case you didn't:

Make sure your user does belong to the newly created
local group OlapAdministrators.

Why install it on XPHome anyway?

HTH Lutz

Just my luck, XP Hom is what came with the computer.
Thank you for your help, I really appreciate it

John Nagy
wizardbeast (AT) worldnet (DOT) att.net

Thank you for taking the time to help me out. The article is most informative.

John Nagy
wizardbeast (AT) worldnet (DOT) att.net