Wednesday, March 7, 2012

Connection fail in analysis service

I got an error when I try to connect my SQL server Analysis service. I have
installed SQL Server Analysis Service in my WinXP PC. When I try to open
Analysis Manager to connect my pc, I got the error "Unable to connect to
registry on the server (COMPUTERNAME), or you are not a member of OLAP
Administrators group on this server."
HOW COME...PLS HELP!!!Check two things:
- is the user a member of Windows local OLAP Administrators group
- do you have SP3a for Analysis Services installed (latest hotfixes for XP
disable accessto the AS is it is not patched).
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Grey" <erickwyum@.i-cable.com> wrote in message
news:%23WSCGGoiEHA.3536@.TK2MSFTNGP12.phx.gbl...
> I got an error when I try to connect my SQL server Analysis service. I
have
> installed SQL Server Analysis Service in my WinXP PC. When I try to open
> Analysis Manager to connect my pc, I got the error "Unable to connect to
> registry on the server (COMPUTERNAME), or you are not a member of OLAP
> Administrators group on this server."
> HOW COME...PLS HELP!!!
>

No comments:

Post a Comment